How to Install Portrait Explorer PAWS / PSS components when SQL Server uses non-default port number

Product Feature: Installation

 

Some customers have reported having a problem with the Explorer PAWS and PSS installers.

The PSS and PAWS installers are failing due to inability to connect to the database server, with the error:

'Error 27502. Could not connect to Microsoft SQL Server 'DATA-SQL01'. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. (17)'.

The user has the required access to the database. The problem is probably that SQL server is not running on the standard port of 1433, it is using port 7895.

The workaround is to specify the database server and port number in the install wizard in the format:

    servername,portno

In this example, the database server would be specified as:

   DATA_SQL01,7895

This is in step 9 of the PSS install instructions, and step 6 of the PAWS install instructions.

http://support.portraitsoftware.com/documentation/Portrait%20Explorer/4.0/1/en-us/en_portrait_explorer_installation_guide.pdf
 

UPDATED:  September 1, 2017