Filter
Top Products
Specifying permissions for the Windows account or Microsoft SQL Server
account
If you install Microsoft SQL Server 2008 R2 Express Edition during the BlackBerry Enterprise Server 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 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 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 Configuration Database on the computer that hosts the BlackBerry Enterprise Server 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 Configuration Database on the computer that hosts the BlackBerry Enterprise Server 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 Configuration Database on the computer that hosts the BlackBerry Enterprise Server 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 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 Configuration Database on a computer that does not host the BlackBerry Enterprise
Server, 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 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.
Installation and Configuration Guide Preinstallation tasks
42