This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Alternate SQL Ports

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.

  • 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.

  • 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