HOW CAN I CHANGE CON. PORT

Fred · Post by **Fred** » Mon 30 May 2005 17:24

Hi, can i change the port wich the MSSQL will connect trugth the internet??ex.: from 1433 to 9191. If i can how can i change it... PLEASE IT`S URGENT

Ikar · Post by **Ikar** » Tue 31 May 2005 07:29

MS SQL doesn't provide functionality to set this parameter through API.

You can use Client Network Utility (included into MS SQL Server package), or make corresponding changes in the registry directly (HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo)