Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Can we use any other port apart from 1433 for Solarwinds DB?

pratikmehta003

Hi All,

Just wanted to confirm if Solarwinds DB can be configured to connect on port other than 1433?

Find more posts tagged with

db port

Accepted answers

neomatrix1217

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.

eg. Solarrwind,1555

All comments

bdufresne

Hello,

Are you speaking strictly Orion Platform to Orion SQL Server? Are you also running DPA or any other type of SQL monitoring?

Bryan

pratikmehta003

Hi Brian,

I am talking strictly Solarwinds server to Solarwinds DB server.

bdufresne

Can I ask why you want to change the port? Are you having issues using 1433?

Bryan

pratikmehta003

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.

neomatrix1217

https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/Change_default_SQL_port

pratikmehta003

its saying i dont have access when i click on this URL...

neomatrix1217

4. To change the port assignment, right-click on the TCP/IP protocol and select Properties.

5. Click on the IP Addresses tab.

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.

eg. Solarrwind,1555

pratikmehta003

Thanks a ton!

So at the fresh installation as well, i can use the custom port, right?

Anything else that i should keep in mind by going with custom port from Solarwinds perspective?

neomatrix1217

Nope.