Browse Search  
Home :MSSQL :

How do I configure the SQL Server Client connection protocol?
Category : MSSQL
 
 

To connect to a remote MS SQL Server over the Internet using SQL clients (Enterprise Manager, Query Analyser,etc) , you will need to use TCP/IP as you network library.  To enable TCP/IP as the connection protocol, follow the below steps

  1. Open the Client Network Utility Configuration  (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
  2. Select the General Tab
  3. Make sure TCP/IP is on top of the list in the 'Enabled Protocols by order' box
  4. Click OK
 
 
This article has been viewed 1016 times.



ASPWebHosting.com.au Copyright © 2004-2005 | All Rights Reserved |

All trademarks are property of their legal owners.