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.
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
Yes. We use a variety of different ones. Did you have a specific implementation question on the SQL side or the SW side?
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.
