09-23-2004, 09:14 AM
Knows Where the Search Button Is
Join Date: Sep 2004
Post Thanks: 0
Thanked 0 Times in 0 Posts
| | Dedicated SQL 2000 SP3 box
Please Login to Remove!
I currently support several BlackBerry 3.6 sp3 servers that all run their own indivdual MSDE database. I am going to be migrating to a dedicated SQL 2000 box that will host a shared BESMgmt database for all of my BES servers.
RIM's documentation is pretty weak on the configuration and specific permissions needed on the database. I have created the database on the SQL server using the creatdb.exe utility "I was also logged onto the SQL box with the BES service account, which is part of the admintrators group on the SQL box".
My question is do I need to do any further permmisoning via the SQL MMC management snap in, or will the database have all the correct permissions required based on the fact that I was logged as the BES service account when I created the database.
Also ... do I need to increase the size of the database, it would appear that it created the database with a default size of 2.5 meg, only leaving me with another .6 meg of available space. What is the recommended size for the database. I will laos leverage this database when I migrate to BES 4.0, which I understand to use the database significantly more than 3.6.