MS SQL Server FAQs

From Hostek.com Wiki
Revision as of 22:58, 25 November 2012 by Jakeh (Talk | contribs) (Created page with "==How to Enable TCP/IP Connections in MS SQL Server== Some versions of SQL Server (including the Express edition) have TCP/IP services disabled by default, which effectively d...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

How to Enable TCP/IP Connections in MS SQL Server

Some versions of SQL Server (including the Express edition) have TCP/IP services disabled by default, which effectively disables remote connections to SQL Server. To enable TCP/IP services, follow these steps:

  1. Open the SQL Server Configuration Manager
    Remote-connections1.png

  2. Expand the SQL Server Network Configuration-->Protocols for SQLEXPRESS section

  3. Right-Click on the TCP/IP item, and click Properties
    Remote-connections2.png

  4. Toggle the Enabled property to Yes.
    Remote-connections3.png

  5. Switch to the IP Addresses tab, and enable the ports you wish to use to access SQL Server
    Remote-connections4.png