actually we are having a customer where they have a shared SQL and there is another tool which is going to use 1433 and informed us that we cannot use the same for Solarwinds and hence this question.
1. On the SQL server, run the SQL Server Configuration Manager. 2. Select the SQL Server Network Configuration. 3. Select from the list the instance you want to configure to listen to on a specific port.
4. To change the port assignment, right-click on the TCP/IP protocol and select Properties.
5. Click on the IP Addresses tab.
Note: Both IP5 and IP6 are disabled and the TCP Dynamic Ports setting is set to “0”, which means that the database engine is listening on dynamic ports. This instance currently uses port number 1433.
6. Specify the port number you want to use instead of 1433 by entering the preferred port number. 7. In order to finish the adjustment, select SQL Server Services, click on SQL Server and restart it.
8. After the SQL ports have been changed, ensure that the new port has been opened for Orion server to communicate with the SQL server.
9. Run configuration wizard on the Orion server to connect to SQL server. At the database setting in the configuration wizard, you need to add the port to the end of the SQL server name.
