Is it possible to use a different SQL port, other than the default 1433?
We would prefer not to use standard ports for communication through firewalls, and the alternate port can help prevent infection by sql viruses looking for the default port.
On the software (Orion) side. When I am installing the NPM software, how do you tell the application to use a port other than 1433. I didn't see any options for this during the install.
If we configure the SQL server to use a different port the install just seems to fail without finding the SQL server.
There are several different ways to do this, the simplest being "SQLSERVER,PORT".
When configuring Orion SQL connection put in YourServerName,1433 or YourServerName,XXXX where YourServerName is the name of your server and XXXX being the port you want to use.
You can also use "cliconfg" to create an Alias.
Really depends on your preference.
-v
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 195,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.