Upgrade Guide

Local Navigation

Configuring connections for the BlackBerry Enterprise Server Express databases

The BlackBerry® Enterprise Server Express stores data in its own database. The database for the BlackBerry Enterprise Server Express is the BlackBerry Configuration Database. You create the BlackBerry Configuration Database when you install a BlackBerry Enterprise Server Express or BlackBerry Administration Service or when you run the CreateDB executable.

The BlackBerry Enterprise Server Express can connect to its database on the Microsoft® SQL Server® using Windows® authentication or database authentication. By default, the BlackBerry Enterprise Server Express logs in to its database using the Windows account that you use to complete the installation process or the database credentials you provided during the installation process.

Specifying permissions when you connect to the BlackBerry Enterprise Server Express database using Windows authentication or Microsoft SQL Server authentication

If you connect the BlackBerry® Enterprise Server Express to the BlackBerry Configuration Database using Windows® authentication or Microsoft® SQL Server® authentication during the installation process, the Windows account or Microsoft SQL Server account that you specify must have database permissions on the database server. The type of permissions that you specify is determined by the setup option that you select and whether you create the BlackBerry Configuration Database on the computer that hosts the BlackBerry Enterprise Server Express components or on another database server.

Specifying permissions for the Windows account or Microsoft SQL Server account

If you install Microsoft® SQL Server® 2005 Express during the BlackBerry® Enterprise Server Express installation process, you might need to specify permissions for the Windows® account or Microsoft SQL Server account, depending on the type of authentication you select.

When you select Windows authentication during the BlackBerry Enterprise Server Express installation process, the setup application automatically assigns the required permissions to the Windows account that you use to complete the installation process.

When you select Microsoft SQL Server authentication during the BlackBerry Enterprise Server Express installation process, you must assign the required database permissions to the Microsoft SQL Server account that you use to complete the installation process.

Assign permissions to the Windows account or Microsoft SQL Server account

Perform one of the following actions:
  • If you create the BlackBerry® Enterprise Server Express databases on the computer that hosts the BlackBerry Enterprise Server Express and you require the setup application to install Microsoft® SQL Server® Express during the installation process and you choose Windows® authentication, 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, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account.
  • If you create the BlackBerry Enterprise Server Express databases on the computer that hosts the BlackBerry Enterprise Server Express and you require the setup application to install Microsoft SQL Server Express during the installation process and you choose Microsoft SQL Server authentication, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Microsoft SQL Server account. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Microsoft SQL Server account.

  • If you create the BlackBerry Enterprise Server Express databases on the computer that hosts the BlackBerry Enterprise Server Express and the computer already hosts a Microsoft SQL Server, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows account or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server Express installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account.
  • If you create the BlackBerry Enterprise Server Express databases on a computer that does not host the BlackBerry Enterprise Server Express, you must assign the database creator (dbcreator server role) Microsoft SQL Server permission to the Windows or Microsoft SQL Server account that you use to complete the BlackBerry Enterprise Server Express installation process. If you want the setup application to install the BlackBerry database notification system, you must assign the Microsoft SQL Server permission for the database system administrator (also called the sysadmin server role in Microsoft SQL Server Management Studio) to the Windows account or Microsoft SQL Server account.

Was this information helpful? Send us your comments.