09-03-2009, 05:15 PM
Join Date: Sep 2009
Post Thanks: 0
Thanked 0 Times in 0 Posts
Thanks. Pretty much exactly what I was looking for. I think I have everything taken care of except for Task 10 (quoted below).
I don't know how to get into the SQL Enterprise Manager/Managent Studio. I installed simply SQL during the BPS install.
If I click on Start--> Programs--> Microsoft SQL 2005--> Configuration Tools I have three options only:
SQL Server Configuration Manager
SQL Server Error and Usage Reporting
SQL Server Surface Area Configuration
None of those appear to be what the instructions are referring to!
I also looked in Control Panel, Administrative Tools and even in the Program Files directory.
By following the instructions, I got rid of the 50093 event ID regarding the registry. Everything seems to work now, meaning I am showing 0 users again. If you know anything about Task 10, I'd appreciate it, otherwise I'll just start searching and read up on adding myself as a user and seeing if I can actually get the device working. Event viewer is more happy (not kicking out numerous errors).
Actually I am getting a Warning Event ID 45058 that states that DBNS component not installed. (EDIT: Looks like I can probably ignore this after further searching).
If you have a Microsoft SQL Server 2005, assign the Server roles by completing the following steps:
1. In the SQL Enterprise Manager/Management Studio, go to Microsoft SQL Servers/SQL Server Group/<SQL_server_name>.
2. Expand the Microsoft SQL Server and expand security.
3. Right-click Logins and click New Login.
4. On the General tab, click the button next to the Name field.
5. Select the new service account name from the Names list, click Add, and click OK.
6. From the Server Roles tab, select Server Administrators and Database Creators from the Server Role list.
Note: If you are running BlackBerry Enterprise Server software version 4.1, add the System Administrators role to add BlackBerry smartphone users in a role-based administration environment. For instructions, see the BlackBerry Enterprise Server for Microsoft Exchange: System Administration Guide.
7. On the User Mapping tab, select the check box for the BlackBerry Configuration Database (for example, BESMgmt).
8. In the Database Roles for <BlackBerry_Configuration_Database_name> list, select the public and db_owner check box and click OK.
Last edited by ksperle : 09-03-2009 at 05:37 PM.