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

¿Fue útil la respuesta?

 Imprimir éste Artículo

Leer también

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

Do you support MSSQL Express?

Yes, we support the MSSQL Express Hosted Edition. If you create .mdf file on your local machine,...

I get "The server principal "username" is not able to access the database "databasename" under the current security context. (Microsoft SQL Server, Error: 916) " after I tried to login via MS SQL Management Studio?

To fix this SQL Server Management Studio 2008 bug please do the following: Open SQL Server...

How do I find my MS SQL Server or Host Address?

Please follow these steps below to obtain that information : Login to your DotNetPanel :...

Do you have any Web Based Enterprise Manager?

No, we don't have that. You can just use MS SQL Management Studio from your local machine and...