Changing the default SQL port for use with ITMS

Products

• IT Management Suite
• Client Management Suite

Issue/Introduction

 You need to use a custom port for communication between Symantec Management Platform and SQL.

Resolution

In order to configure the custom port, you will need to configure the client port and the default SQL port. 

 

In the SQL Server Configuration Manager (Start -> Microsoft SQL Server -> Configuration Tools -> SQL Server Configuration Manager) : Expand the SQL Native Client and double click on Client Protocols 

 

Right Click on TCP/IP and change the default port to the one that you would like to work with, then OK

 

Then expand the SQL Server Network Configuration and highlight the Protocols for MSSQLSERVER (or the instance name)

 

From the righthand side right click on TCP/IP -> Properties.

 

 

 

 

Change the TCP Port in the correct places (in the IP addresses that you would it to be changed for example IP1, IP2 ) make sure that you scroll down and change the IPAll as well to the custom port. The TCP Dynamic port should be blank under all the IPs, if  you see 0, please be sure to delete it.

 

 

Now restart the SQL server services and go to the Notification Server and Open Symantec Installation Manager, and make the change to the 'new' database and port.

 

Go to -> Configure Settings > Configure Database Settings

 

In the SQL Server name, type the Server Name or ip address, comma Custom Port number.  For example: Server,9000 OR 192.168.X.X,9000

 

 

 

After you have changed the server name, make sure that the option Use existing database is checked and the correct database is selected.

 

Click Save Changes and it should restart the Altiris service and now the custom port should be working, you would have to repeat the same steps for all of your Notification Servers.