how to get and change the TCP/IP port in sql 2005 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

how to get and change the TCP/IP port in sql 2005

can i get the navigation to get and change the TCP/IP port no, in sql server 2005
Yes you can change the TCPIP port number. Refer the link http://msdn2.microsoft.com/en-us/library/ms177440.aspx Sagar
You have to use SQL Server Configuration Manger…
Start/All programs/sql server 2005/SQL Server Configuration Manger
Expand "SQL Server 2005 Network Configuration"/Protocol for sql…/On the right sie double click TCP/IP/ip addresses/
All the way bottom you see the port mumber and it can be changed…. http://technet.microsoft.com/en-us/library/ms174212.aspx MohammedU.
Microsoft SQL Server MVP
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
But ensure that port is open on the network, otherwise SQL service will not be started. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>