To run Database Configuration after installation with a Microsoft SQL Server database driver, complete the following steps:
- On the login screen, click Edit database configuration.
- On the Database Configuration wizard, select an alias from the list, or click Add to create a new alias. If you crete a new alias, enter a name in the Database Alias field.
- In the Driver Type list, select Microsoft SQL Server / SQL Express.
- In the Connection String field, enter the connection string to your database.
- If you are not using a named instance, enter the connection string in the format
<server name>,<port>/<database name>.For example,
p6server.nesbidcorp.com,1234/PMDB - If you are using a named instance, enter the connection string in the format
<server name>\<instance name>/<database name>.For example,
p6server.nesbidcorp.com\primavera/PMDB
- If you are not using a named instance, enter the connection string in the format
- If your database is encrypted using a database key, in the Select database key section:
- If you want to use the default key for the database, select Use Default Database Key.
- If you do not want to use the default key:
- In the Key File Name field, click Browse.
- In the Open dialog box, browse to your key file and click Open.
- In the Key Name list select the key to use.
- Click Next.
- In the Enter public login Information section, enter your public login information that was defined by your administrator.
- Click Test to test the database connection. If the connection is successful, click Save. If the connection is not successful, revise the database connection information you provided.