Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - Enabling TCP/IP Protocol on a SQL Server

By: FYIcenter.com

(Continued from previous topic...)

How To Enable TCP/IP Protocol on a SQL Server?

By default, the TCP/IP protocol is turned off when a SQL Server is installed to reduce security risk. But if you want applications to connect and access the SQL Server, you need to enable the TCP/IP protocol on the server by following this tutorial:

1. Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Configuration Manager.

2. Double click on "SQL Server 2005 Network Configuration" to see the list of SQL Server instances.

3. Click on "Protocols for SQLEXPRESS". You will see a list of protocols.

4. Right-mouse click on TCP/IP and select the "Enable" command. See the picture below:
    TCP/IP Protocol Enabled

5. Click on "SQL Server 2005 Services". You will see two services.

6. Right-mouse click on "SQL Server (SQLEXPRESS)" and select restart to finish the TCP/IP protocol setting change.

Your SQL Server is ready to accept network connection now.

(Continued on next topic...)

  1. What Is Open Database Communication (ODBC)?
  2. How To Add a New DSN with the ODBC Driver for SQL Server?
  3. How To Define the Name and Server for a new DSN?
  4. How To Provide Login Information for a New ODBC DSN?
  5. Why Are You Getting Errors When Creating a New ODBC DSN?
  6. What Are the Requirements on SQL Server Network Connections?
  7. How To Start SQL Server Browser Service?
  8. How To Enable TCP/IP Protocol on a SQL Server?
  9. How To Verify the Port Number of the SQL Server?
  10. How To Configure ODBC DSN with Different Port Numbers?
  11. How To Configure and Test ODBC DSN Settings?
  12. How To Connect MS Access to SQL Servers through ODBC?
  13. How Can Windows Applications Connect to SQL Servers via ODBC?

Related Articles:


Other Tutorials/FAQs:


Related Resources:


Selected Jobs: