BlackBerry Forums Support Community

BlackBerry Forums Support Community (http://www.blackberryforums.com/)
-   BES Admin Corner (http://www.blackberryforums.com/bes-admin-corner/)
-   -   Dedicated SQL 2000 SP3 box (http://www.blackberryforums.com/bes-admin-corner/652-dedicated-sql-2000-sp3-box.html)

pzkzm9 09-23-2004 10:14 AM

Dedicated SQL 2000 SP3 box
 
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.

Thanks

gsx95 10-01-2004 11:16 PM

the bes service account needs to be local admin on the box.


All times are GMT -5. The time now is 01:06 PM.

Powered by vBulletin® Version 3.6.12
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.