Setting Database Owner and Security Administration Permissions

Permissions are required in SQL Server to create and manage Microsoft Dynamics NAV databases. Use SQL Server Management Studio to grant these permissions to Microsoft Dynamics NAV administrators.

If you have installed SQL Server with the guidelines in Installation Considerations for Microsoft SQL Server, then SQL Server Management Studio is already installed on your computer. Otherwise, update your SQL Server installation to include the Management Tools - Complete option for SQL Server.

Permissions for Using and Creating Databases

The administrator who installs Microsoft Dynamics NAV 2016 automatically has access to the Microsoft Dynamics NAV database in the development environment. To grant another user permission to create new databases in development environment, grant that user the sysadmin Server Role for the Microsoft Dynamics NAV SQL Server instance in SQL Server Management Studio.

Note

The administrator must also have a Microsoft Dynamics NAV 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 Microsoft Dynamics NAV 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 Microsoft Dynamics NAV databases in the Microsoft Dynamics NAV development environment, the account running Microsoft Dynamics NAV Server is automatically granted the db_owner database role for these databases.

Permissions for Managing Companies, Objects, and Licenses

Administrators who create Microsoft Dynamics NAV databases automatically have permission to manage companies, objects, and licenses in that database.

To grant permission to manage companies, objects, and licenses in Microsoft Dynamics NAV Development Environment to additional administrators, assign those administrators the db_owner database role for all relevant Microsoft Dynamics NAV databases.

To grant the db_owner role on a Microsoft Dynamics NAV 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 Microsoft Dynamics NAV 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

Concepts

Installation Considerations for Microsoft SQL Server