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 dit antwoord nuttig?

 Print dit artikel

Lees ook

Can I use mssql 2008 if I built my database using mssql 2005?

Yes you can use the mssql 2008 although you build your db using mssql 2005. The database can be...

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

Do you support MSDE 2000?

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

How do I access SQL Server 2008 Database using SQL Server Management Studio?

Please follow the steps listed below in order to access or connect your SQL 2008 database using...