How do I configure the SQL Server Client connection protocol?
Category :
MSSQL
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
|