Configuring connections for the BlackBerry Enterprise Server databases
The BlackBerry® Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service store data in their own databases. The database for the BlackBerry Enterprise Server is named the BlackBerry Configuration Database.
You can create the BlackBerry Configuration Database by installing a BlackBerry Enterprise Server instance or BlackBerry Administration Service instance, or by running the CreateDB executable. You can create the BlackBerry MDS Integration Service database or BlackBerry Monitoring Service database during the installation processes for the BlackBerry MDS Integration Service or BlackBerry Monitoring Service respectively.
The BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service can connect to the databases on the Microsoft® SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server, BlackBerry Monitoring Service, and BlackBerry MDS Integration Service log in to the databases using the Windows account that you use to complete the installation process, or the database credentials you provided during the installation process.
To support Microsoft SQL Server 2005 database mirroring with the BlackBerry Configuration Database or BlackBerry MDS Integration Service database, you must use Windows authentication. The BlackBerry Monitoring Service does not support database mirroring.
Specifying permissions when connecting to the BlackBerry Enterprise Server databases using Windows authentication
During the installation process, if you connect the BlackBerry® Enterprise Server, BlackBerry MDS Integration Service, and BlackBerry Monitoring Service to the BlackBerry® Enterprise Server databases using Windows® authentication, the Windows account that you specify must have database permissions on the database server. The type of permissions depends on the setup option that you select, and whether you create the BlackBerry Enterprise Server databases on the same computer as the BlackBerry Enterprise Server components or on another database server.
Specifying Microsoft SQL Server 2005 Express permissions for the Windows account
If you install Microsoft® SQL Server® 2005 Express during the BlackBerry® Enterprise Server installation process, you do not need to specify additional permissions. When you select Windows® authentication during the BlackBerry Enterprise Server installation process, the setup application automatically assigns the required permissions to the Windows account that you use to complete the installation process.
Assign Microsoft SQL Server permissions to the Windows account
- If you create the BlackBerry® Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and require the setup application to install Microsoft® SQL Server® Express during the installation process, you are not required to assign Microsoft SQL Server permissions to the Windows® account. If you want the setup application to install the BlackBerry database notification system, assign the system administrator permission to the Windows account.
- If you create the BlackBerry Enterprise Server databases on the computer that hosts the BlackBerry Enterprise Server and the computer already hosts a Microsoft SQL Server, assign the database creator permission to the Windows account that you use to complete the BlackBerry Enterprise Server installation process. If you want the setup application to install the BlackBerry database notification system, assign the system administrator permission to the Windows account.
- If you create the BlackBerry Enterprise Server databases on a computer that does not host the BlackBerry Enterprise Server, you can assign the database creator permission to the Windows account that you use to complete the BlackBerry Enterprise Server installation process.
Configuring authentication to the BlackBerry MDS Integration Service database
When the setup application creates the BlackBerry® MDS Integration Service database during the installation process, you must use the same authentication method and account that you specified for the BlackBerry Configuration Database. The BlackBerry MDS Integration Service requires the same permissions to access the BlackBerry MDS Integration Service database that the BlackBerry® Enterprise Server requires to access the BlackBerry Configuration Database.
Add Windows credentials to the local system account
Add database credentials to the local system account
- On the computer that you want to install the BlackBerry® Enterprise Server software on, on the Start menu, click Run.
- Type regedit.
- Click OK.
- In HKEY_USERS\.DEFAULT\Software\Research In Motion\BlackBerry Enterprise Server\Database, create the following string values for a database account that has the required permissions:
Create a BlackBerry Configuration Database
- Log in to the computer that hosts the database server using a local administrator account or a Windows account that has SQL administrator permissions.
- Copy the BlackBerry® Enterprise Server installation media to the database server that you want to configure as the host server for the BlackBerry Configuration Database.
- Extract the contents to a folder on the computer.
- Navigate to <extracted_folder>\Database.
- Open the BesMgmt.cfg file in a text editor.
- Change the file to include information that is specific to your organization's environment.
- Save and close the file.
- Open a command prompt window.
- Change to <extracted_folder>\Database.
- Type CreateDB.exe BESMgmt.cfg.