View Single Post
Old 02-25-2009, 10:32 PM   #9 (permalink)
Knows Where the Search Button Is
Join Date: Sep 2008
Model: Bold
Carrier: Vodafone
Posts: 17
Post Thanks: 0
Thanked 0 Times in 0 Posts

Originally Posted by knottyrope View Post
Did you do this too?

1: Assign appropriate permissions

In the SQL Enterprise Manager, go to Microsoft SQL Servers > SQL Server Group > <SQL_server_name>.
Expand the Microsoft SQL Server selection and expand Security.
Right-click Logins and click New Login.
Type the new name.
For Windows Authentication

On the General tab, click the button to the right of the Name field.

Select the new service account name from the Name list.
Click Add.
Click OK.
For Microsoft SQL Server Authentication

On the General tab, type the name of the Microsoft SQL Server account.
Select the SQL Server Authentication option.
Type the password for the Microsoft SQL Server account.
Click Add.
Click OK.
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 or later, adding the System Administrators role allows you to add BlackBerry smartphone users in a role-based administration environment. For instructions, see the BlackBerry Enterprise Server for Microsoft Exchange: System Administration Guide.

On the Database Access tab, perform the following steps:
Select the check box for the BlackBerry Configuration Database (for example, BESMgmt).
In the Database Roles for <BlackBerry_Configuration_Database_name> list, select the db_owner check box.
Close SQL Enterprise Manager.
I did the relevant parts to MS SQL there, you've mixed up MSDE into it so I didn't do those bits...
Offline   Reply With Quote