Configuring minimum Microsoft SQL Server permissions for the Windows account that is used to run the BlackBerry MVS

The Windows account that you use when you run the BlackBerry Mobile Voice System setup application must have Microsoft SQL Server permissions. However, the setup application requires more permissions to install or upgrade the BlackBerry MVS software than are required to run the BlackBerry MVS. The setup application requires the additional permissions so that it can update the BlackBerry Configuration Database with BlackBerry MVS information.

After the installation or upgrade process completes, you can change the Microsoft SQL Server permissions of the Windows account to the Microsoft SQL Server permissions that the BlackBerry MVS requires to run. When you change the Microsoft SQL Server permissions of the Windows account, you can use Microsoft SQL Server security to restrict the operations that the Windows account can perform on the BlackBerry Configuration Database.

The following table describes the Microsoft SQL Server permissions for the setup application and the Windows account that the BlackBerry MVS uses to run.

Server and database roles

Description

db_owner

The setup application requires this role to update the BlackBerry Configuration Database with BlackBerry MVS information.

You can remove this role from the Windows account that the BlackBerry MVS uses to run after the setup application updates the BlackBerry Configuration Database.

rim_db_mvs_apps

The BlackBerry MVS requires this role to run the BlackBerry MVS Services. The setup application creates this role automatically when it updates the BlackBerry Configuration Database during the installation of the BlackBerry MVS software.

This role has the minimum Microsoft SQL Server permissions that are required for running the BlackBerry MVS Services.


Was this information helpful? Send us your comments.