Edit

Granting Permissions to Manage Business Central Databases in SQL Server

  • Article

Special permissions are required in SQL Server to create and manage Business Central databases, for example by using Business Central Administration Shell or development environment. To grant these permissions to Business Central administrators, use SQL Server Management Studio.

Permissions for using and creating databases

The administrator who installs Business Central automatically has access to the database. To give another user permission to create new databases, grant that user the sysadmin Server Role for the Business Central SQL Server instance in SQL Server Management Studio.

Note

The administrator must also have a Business Central developer's license to use the development environment, and be assigned the SUPER permission set.

In the Object Explorer pane in SQL Server Management Studio, follow these steps after connecting to the Business Central SQL Server instance:

  1. Expand the Security node, right-click Logins, and choose New Login.

    If the administrator already has a login, right-click the user and choose Properties. Then go to step 4.

  2. In the Login – New dialog box, select Search.

  3. In the Select User or Group dialog box, select a valid Active Directory user.

  4. In the Login – New dialog box, under Select a Page, choose Server Roles. Select the sysadmin check box.

  5. Choose the OK button to close the Login – New dialog box.

When administrators create Business Central databases, the account running Business Central Server is automatically granted the db_owner database role for these databases.

Permissions for managing companies, objects, and licenses

Administrators who create Business Central databases automatically have permission to manage companies, objects, and licenses in that database.

To grant permission to manage companies, objects, and licenses to additional administrators, assign those administrators the db_owner database role for all relevant Business Central databases.

To grant the db_owner role on a Business Central database in SQL Server Management Studio, follow these steps:

  1. If the administrator is not already a SQL Server login, add the administrator as a login by following the first three steps in the procedure above.

  2. Select the Business Central database, then Security, then right-click Users and choose New User.

    Choose the button at the right of the Login Name field to open the Select Login dialog box.

  3. Choose the Browse button, select the check box for the relevant login, and then choose the OK button.

  4. Choose the OK button to exit the Select Login dialog box.

  5. Enter a User name for the user.

    This can be the same as the login name.

  6. In the Database User - New dialog box, under Select a Page, choose In the Database role membership.

  7. Select the db_owner check box.

  8. Choose the OK button to exit the Database User – New dialog box.

See Also

Installation Considerations for Microsoft SQL Server
Security and Protection