Creating the navigation database - Microsoft SQL Server

To create the navigation database with a Microsoft SQL Server data source connection:

  1. Open the default navigation page. You are redirected to the CPM Navigation Database Creation Utility page if you do not already have a navigation database.
  2. From the Database Server Type list, select SQL Server.
  3. In the SQL Server Instance field, specify the name of the server computer on which the SQL Server software is installed. If a SQL instance is used, it must be appended to the name. For example, MyServerName\SQL2019.
  4. In the Database Administrator User ID field, specify the database administrator user ID.
  5. In the Database Administrator Password field, specify the password for the database administrator.
  6. In the Data Source Name field, specify the name for the data source. The default is Navigation.
  7. In the Navigation Database Name field, specify the name for the navigation database.
  8. In the Navigation Database Owner ID field, specify the User ID of the navigation database owner.
  9. In the Navigation Database Owner Password field, specify the password for the navigation database owner.
  10. Select the Database Directory Location check box to use the default directory for Microsoft SQL Server Management Studio.
  11. Click Test Connection.
  12. Click Create Database.