Technical FAQs

Ask a Question

How to use a port other than 1433 for SQL transactions with PME7.2 / SPM7.0.1

Issue:
Use a port other than 1433 for SQL transactions with PME7.2 / SPM7.0.1

Product Line:
Power Monitoring Expert 7.2.x
Struxureware Power Monitoring 7.0.x

Environment:
Power Monitoring Expert 7.2.x
Struxureware Power Monitoring 7.0.x

Cause:
When port 1433 is blocked or unavailable

Resolution:

Port 1433 is the default port used by SQL for all transactions. If port 1433 is blocked and a different port needs to be used, then perform the following steps after installing SQL, but before installing the StruxureWare:

1. On the application server, create an alias using the SQL Server Client Network utility (start->run->cliconfg) that comes as part of the Windows OS installation.



2. Click on the Alias tab and then click the Add button



3. Select TCP/IP, enter the server name, and uncheck "Dynamically determine port"

4. Change the Port Number to the new port that is is being used (if the new port is 1436, for example, enter 1436 in this field)



After these steps are completed, running the StruxureWare installer on the Application Server will now connect to the correct port.

Was this helpful?
What can we do to improve the information ?