changing port number - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

changing port number

Author

Topic

putane.sanjay
Yak Posting Veteran

77 Posts

Posted - 2006-12-12 : 03:15:30

HI

WE ARE USING SQL SERVER 2000 & WE ARE USING 1433 PORT NUMBER
I WANT TO KNOW HOW TO CHANGE THE PORT NUMBER TO SOME OTHER PORT NUMBER WHEN THE SQL SERVER IN RUNNING.

PLEASE HELP ME

REGARDS
P.M.SANJAY

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-12-12 : 03:20:13

You don't say wether it is SQL 2000 or SQL 2005 you use, so I used GOOGLE for 30 seconds

http://www.learnsqlserver.com/VideoTutorials/Sql-Server-Video/324/How-to-Change-SQL-Server-TCP-IP-Port-Number-Using.aspx
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1219962,00.html

Peter Larsson
Helsingborg, Sweden

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-12-12 : 15:49:40

quote:
Originally posted by Peso

You don't say wether it is SQL 2000 or SQL 2005 you use, so I used GOOGLE for 30 seconds

Ummm.... Peter? Read the first sentence of the OP's text. It clearly says

quote:

WE ARE USING SQL SERVER 2000 & WE ARE USING 1433 PORT NUMBER

P.M. Sanjay,

Run SvrNetCn.exe, found in the SQL Server BINN directory. Click on TCP/IP in the right pane, and then click the Properties button. You can change the port there.

You'll have to restart SQL Server for the change to take effect, though; you can make the change while the server is running, but it won't do anything until the restart is done.

Ken

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2006-12-12 : 17:33:04

Sir, Cut back on the coffee