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

Esta resposta lhe foi útil?

 Imprimir este Artigo

Veja também

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

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?

This happens because the customer has added Guest Access/Public to their SQL...

How can i generate scripts for MS SQL Database?

Your default database user don't have privillages to do that You can just create a support...

How to use SQL Management Studio Express 2005?

Open your SQL Management Studio Express 2005 on your local machine.Step 1) Type the ServerName:...

Can I have more than 1 database with my MS-SQL account?

Yes, please contact us at sales@seekdotnet.com for more information. We provide a flexible web...