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
  • 276 Users Found This Useful
Was this answer helpful?

Related Articles

How do I get a copy of MS SQL Enterprise Manager and Query Analyser?

Microsoft does not distribute MS SQL client tools individually, they are bundled with MS SQL...

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...

Do you support MSDE 2000?

No. We do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...

Can I have more logins for my MS SQL database?

For old In House Control Panel : No. We only provide a single database user login. For...

How do I obtain the MS SQL database disk usage?

Execute this command in Sql Query Analyzer exec sp_spaceused The database size is measured in...