Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can you change the port number of a SQL Server instance? 1

Status
Not open for further replies.
lory

lory

MIS
Nov 20, 2001
35
US
I have a W2K Server with SQL Server 2000 SP2 installed. The port number is 1433 (default), but we need to change it. Is it possible to change this port number or do I have to reinstall?
 
Sort by date Sort by votes
Run the sql server network utility. If you loaded the client tools it should be on your start menu.

Select tcp/ip and press the properties button.

You can change the port from there.

You will need to restart sql server for the change to take effect.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
439
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
386
CodeWell
CodeWell
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
309
dhookom
dhookom
Ikatiemarie
  • Locked
  • Question
SQL Server 2008 SP_Send_dbmail
Replies
0
Views
900
Ikatiemarie
Ikatiemarie
dgillz
  • Locked
  • Question
SQL View not available to Excel Power Query
Replies
1
Views
308
dgillz
dgillz

Part and Inventory Search

Sponsor

Back
Top