I have a BlackBerry Enterprise sever that has broken after the DST2007 patch. I know that there is a way to fix this according to their database, but since the services were being run by ADMINISTRATOR (Not good), I thought I'd take this chance to fix it RIGHT. What I want to do is get the services to run as "BESADMIN", so I created the user "BESADMIN", gave it rights as appropriate (ESM --> server object --> security --> advanced --> Add 'BESADMIN' with SEND AS, RECEIVE AS, and ADMINISTER STORE (according to BB Documentation). After setting the services with the new credentials, all of the services except for "BLACKBERRY ROUTER" fail to start with the error "UNABLE TO ATTACH TO DATABASE". I suspect that this is because of permissions IN the database itself.
(PS: This is running under MSDE 2000 rel. A (latest MS download of MSDE that isn't SQLEXPRESS), and everything runs fine with domain\ADMINISTRATOR running the services)
I think what I need to be able to do is:
- Verify that the user 'DOMAINNAME\BESADMIN' has rights to this database (using OSQL I guess? unless someone has a better way without installing SQL 2000 admin tools)
- If the user does NOT have rights, how do I ADD the user and grant the rights? (Again, OSQL, I guess?)
Unless there's an easier way to change up the service account in Blackberry Enterprise? Officially what I'm doing is changing the SERVICE ACCOUNT of Blackberry Enterprise Server v4.1, but I didn't see any documentation that reflected how to do this on Blackberry's webpage.
Any help is greatly appreciated. Thanks!