How to change SQL Server default port setting of 1433 on a client computer

Article:TECH114207  |  Created: 2008-01-12  |  Updated: 2008-01-12  |  Article URL http://www.symantec.com/docs/TECH114207
Article Type
Technical Solution


Issue






Solution



Use the SQL Server Client Network Utility to change the default port used for SQL communication.
  1. Launch %windir%\System32\cliconfg.exe.
  2. Highlight TCP/IP under the Enabled protocols window.
  3. Click the Properties button.
  4. Enter in the new port number, then click OK.
  5. Restart the computer for the changes to take effect.

NOTE: On the computer hosting the SQL server, the executable is "svrnetcn". For more information, see "Control Compliance Suite (CCS) Reporting & Analytics client fails to launch" at http://service1.symantec.com/support/intrusiondetectkb.nsf/docid/2007121209393153.





Legacy ID



2008031215144953


Article URL http://www.symantec.com/docs/TECH114207


Terms of use for this information are found in Legal Notices