Monday, March 26, 2012

How to change port number of mssql2000?

Hi,
May I ask how to change the default listening port of MSSQL2000?
ThanksHi,
From SQL server program groups, select "Server network utility". Click TCPIP
and select properties to change port number. After changing the port stop
and start MSSQL server service.
Thanks
Hari
MCDBA
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Hi -
Please refer to KB Article
http://support.microsoft.com/defaul...kb;EN-US;815146
Thanks
-Surajit
"Tom" <Tom@.discussions.microsoft.com> wrote in message
news:473A349F-1471-43F5-9EF1-D861AF9DA7E5@.microsoft.com...
> Hi,
> May I ask how to change the default listening port of MSSQL2000?
> Thanks|||Enabled Protocols and Tom
As long as you are using TCP/IP You can change the port number by using the
SQL Server network utility.
You need to be logged on to the server where SQL server is running. Click s
tart, then programs, then Microsoft SQL server, then server network utility
(not client network utility). Choose the instance you want to change. High
light TCP/IP from enabled p
roperties and click on properties. You can change the port number there.
Hope this helps
Johnsql

No comments:

Post a Comment