3 Replies Latest reply on Mar 8, 2010 1:45 PM by viol8tor

    Alternate SQL Ports

    chhamilt

      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.

        • Re: Alternate SQL Ports
          viol8tor

          Yes.  We use a variety of different ones. Did you have a specific implementation question on the SQL side or the SW side?

            • Re: Alternate SQL Ports
              chhamilt

              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.

                • Re: Alternate SQL Ports
                  viol8tor

                  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