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

Warning

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

Note

After you have created the database, you can enter program objects and company data. Before you can create company data, you must import some basic data from a backup copy of the original standard database, which is the database that comes with Microsoft Dynamics NAV. The backup must at least include Data Common to All Companies and Application Objects. Data Common to All Companies includes the program's report list and permission groups. When you restore the Application Objects, the accounting application is transferred to the database.

See Also

Tasks

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