Running Database Configuration After Installation with a Microsoft SQL Server Database Driver
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 create 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 Keystore section:
- If you want to use the default key for the database, select Use default database keystore.
- If you do not want to use the default key:
- In the Keystore file 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.
Related Topics
Running Database Configuration After Installation
Prerequisites for Connecting to Autonomous Databases
Running Database Configuration After Installation with an Oracle Database Driver
Running Database Configuration After Installation with a Cloud Connect Database Driver
Configuring an Oracle Database Connection From the Command Line
Configuring a Microsoft SQL Server Database Connection From the Command Line
Last Published Tuesday, December 12, 2023