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 :
- Open the Client Network Utility Configuration (Start -> Programs -> Microsoft SQL Server -> Client Network Utility)
- Select the General Tab
- Make sure TCP/IP is on top of the list in the 'Enabled Protocols by order' box
- Click OK
Ha estat útil la resposta?
Please follow the steps listed below in order to access or connect your SQL 2008 database using...
No, we only provide a single database user login.
No, we do not support MSDE 2000. The Microsoft SQL Server 2000 Desktop Engine (MSDE 2000) is a...
From the Start Menu, select Programs -> Microsoft SQL Server -> Import and...