How do I configure the SQL Server Client connection protocol?

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

Was this answer helpful?

 Print this Article

Also Read

I am able to view and access a SQL database other than my own while connected with Enterprise Manager, Query Analyzer, or the SQL Web admin. What is wrong?

...

Change collation type in SQL Server

To change a collation of database use this statement. USE Tempdb GO ALTER DATABASE Pubs COLLATE...

I get "SQL Server does not exist or access is denied" error when I tried to connect to MS SQL database on your server?

This error indicates that Enterprise Manager or Query Analyzer cannot make a connection the...

How to Transfer SQL database from My Database Server to your Database Server

From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...

Cannot expand Databases in Management Studio

Error: Management Studio Express 2008 to access my shared hosted SQL 2005 / 2008 Standard. I...