Saturday 22 October 2011

Get or Change MS SQL server TCP/IP

How to get or change MS SQL TCP/IP?
  1. Open Sql Server Configuration Manager.
  2. Open SQL server network configuration.
  3. Press on Protocols for MSSQLSERVER.
  4. Right click on TCP/IP -> Enable. Look at the figures  bellow.


Double Click on TCP/IP will show the figure bellow 

Go to IP All Section and look at the TCP Port Field if is it empty write 1433 which is the default port for the SQL server.

Best Wishes, 

Mohammad Abu Hmead

No comments:

Post a Comment