ERROR: "Database Connection Error" when installing Blueprint Administrator on a remote system
  • 23 Apr 2024
  • 1 Minute to read
  • Dark
    Light
  • PDF

ERROR: "Database Connection Error" when installing Blueprint Administrator on a remote system

  • Dark
    Light
  • PDF

Article summary

Symptoms:

  • ERROR: "Database Connection Error"

  • Installing Blueprint Administrator on remote machine results in error

Environment:

  • Pharos Systems Blueprint Enterprise

  • Microsoft SQL Server


Cause:

Installing Blueprint Administrator on remote systems create connections to the database (using the credentials gleaned from the Analyst) so that it can do its work. If the Microsoft SQL Server is using non-standard ports and/or SQL Browser is not running, it can fail to make the SQL connection, and so fail to run, even though the initial connection to the Blueprint Analyst server succeeds.

Resolution:

Append the correct TCP port to the server name within the client computer's GlobalConfig.xml file, created during Administrator installation.

1. Open the GlobalConfig.xml file (by default, found in C:\ProgramFiles\PharosSystems\Blueprint) in NotePad. You may need to execute NotePad as an administrator. 2. Find the <DataSource> XML tag. The value within the tag is the name/instance of the SQL Server. 3. Append the TCP port to the server name by placing the port number (for example, 15000) at the end of the server's name with a comma (,) separating the two. This forces the .NET client that we use for the SQL connection to utilize that port number.

<DataSource>SQLServerName,15000</DataSource>

NOTE: Blueprint Enterprise 5.0 and 5.1 will have two <DataSource> tags; one for the Operational database, and another for the Warehouse database. Ensure that it is modified in both places. They are highlighted in the graphic below.


Was this article helpful?


Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.