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 2013 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 dbcreator and securityadmin Server Roles for the Microsoft Dynamics NAV SQL Server instance in SQL Server Management Studio.
|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:
- 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.
- In the Login - New dialog box, select
- In the Select User or Group dialog box, select a valid
Active Directory user.
- In the Login - New dialog box, under Select a
Page, choose Server Roles. Mark the dbcreator and
securityadmin check boxes.
- Choose OK to close the Login - New dialog
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:
- If the administrator is not already a SQL Server login, add the
administrator as a login by following the first three steps in the
- Select the Microsoft Dynamics NAV database, then
Security, then right-click Users and choose New
Choose the button at the right of the Login Name field to open the Select Login dialog box.
- Put a mark in the check box for the relevant Login and choose
- Choose OK to exit the Select Login dialog
- Enter a User name for the user.
This can be the same as the login name.
- In the Database role membership list at the bottom of
the Database User dialog box, select the db_owner check
- Choose OK to exit the Database User - New dialog