Setting Database Owner and Security Administration Permissions

Permissions are required in SQL Server to create and manage Dynamics NAV databases. Use SQL Server Management Studio to grant these permissions to 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 2018 automatically has access to the 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 Dynamics NAV SQL Server instance in SQL Server Management Studio.

Note

The administrator must also have a 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 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 Dynamics NAV databases in the 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 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 Dynamics NAV databases.

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

Installation Considerations for Microsoft SQL Server