How to: Create Databases

When you create a database you must specify the SQL Server instance for the database and the authentication type.

To create a database

1. In the development environment, on the File menu, choose Database, and then choose New.

2. In the Server Name field, enter the name of the SQL Server instance. You can choose the up arrow to select the server from a list of available servers or you can enter the server name manually.

3. In the Authentication field, select the type of authentication that you require. Choose the drop-down arrow to select Database Server Authentication or Windows Authentication.

   • If you select Database Server Authentication, then authentication is performed by the SQL Server instance that you have selected.

   • If you select Windows Authentication, then authentication is performed by the Windows domain controller.

4. In the User ID field, enter your User ID if you have selected Database Server Authentication.

5. In the Password field, enter your password if you have selected Database Server Authentication.

6. To set the network type to be used when connecting to the server, choose the Advanced tab and select the net type from the drop down list box in the Net Type field. However, it is not usually necessary to change the network type from the default setting. The Default net type setting allows Microsoft Dynamics NAV to connect to a server using the default client network type assigned by SQL Server. You can change the net type with the Client Network Utility, which is part of the SQL Server Client Utilities, if they have been installed on the client computer.

7. Choose OK to connect to the server and open the New Database window.

   In the New Database window, enter the information about the database that you want to create. The window contains the same tabs as the Alter Database window. The tabs are the following:

   • Altering Databases - General Tab

   • Altering Databases - Database Files Tab

   • Altering Databases - Transaction Log Files Tab

   • Altering Databases - Collation Tab

   • Altering Databases - Options Tab

   • Altering Databases - Integration Tab

   • Altering Databases - Advanced Tab

Now that you have created the database, you must configure your Microsoft Dynamics NAV Server instance to access the database and then restart the service. For more information, see How to: Configure a Microsoft Dynamics NAV Server Instance. Next, you must run the Sync-NAVTenant cmdlet to synchronize the database table schema. For more information, see Microsoft Dynamics NAV Windows PowerShell Cmdlets. Alternatively, you can set the Prevent data loss from table changes property to No. However, in that case, you must change the property back to Yes once you have imported the objects that you want to import.

Warning

You can always enlarge a database later on, but you cannot make it smaller.

After you have created the database, you can enter program objects and company data. Before you can create company data, you must import your application and other basic data from another Microsoft Dynamics NAV database. For more information, see the MicrosoftDynamicsNAV2013R2CU8_ImportExportData.pdf file that is available on the W1 version of the download media for Microsoft Dynamics NAV 2013 R2 CU8 and subsequent cumulative updates for Microsoft Dynamics NAV 2013 R2.

See Also

Tasks

How to: Create Companies
How to: Select the Network Type of the Database
How to: Delete Databases