Configuring Client Computers for a Non-Default Microsoft SQL Server Port

If you use a port other than the default (1433) to connect to your Microsoft SQL Server P6 Professional database, you might need to perform additional configuration steps. To determine if you need to perform those steps, complete the following steps after installing P6 Professional:

  1. Launch P6 Professional from the client computer.
  2. Choose Help, About Primavera P6 Professional.
  3. From the About Primavera P6 Professional dialog box, click the System tab.
  4. Under BRE Database, locate the database port number.
  5. If the non-default port number appears, no further action is necessary and you can proceed to the next topic.

    If port number 1433 is listed, the user does not have Microsoft SQL Server 2005 Backward Compatibility Components installed. Proceed to the next step.

  6. Choose to either globally specify the connection string in the P6 Professional database SETTINGS table or install Microsoft SQL Server 2005 Backward Compatibility Components on each client computer.

    See Database Administrator Settings for a Non-Default Microsoft SQL Server Port if you choose to specify the connection string. If you choose to configure each client computer, proceed to the next step.

  7. Go to http://www.microsoft.com/en-us/download/details.aspx?id=15748.
  8. Download the Microsoft SQL Server 2005 Feature Pack (In the Choose the Download You Want menu select SQLServer2005_BC_x64.msi.

Related Topics

Running Database Configuration After Installation

Configuring a Microsoft SQL Server Database Connection From the Command Line



Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Friday, March 19, 2021