Difference between revisions of "MS SQL Server FAQs"

From Hostek.com Wiki
Jump to: navigation, search
(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...")
 
(How to Enable TCP/IP Connections in MS SQL Server)
Line 2: Line 2:
 
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:
 
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:
 
#Open the SQL Server Configuration Manager<br />[[File:Remote-connections1.png]]<br /><br />
 
#Open the SQL Server Configuration Manager<br />[[File:Remote-connections1.png]]<br /><br />
#Expand the ''SQL Server Network Configuration''-->''Protocols for SQLEXPRESS'' section<br /><br />
+
#Expand the ''SQL Server Network Configuration''-->''Protocols for SQLEXPRESS'' section (it may be named ''Protocols for MSSQLSERVER'' in some installations.)<br /><br />
 
#Right-Click on the TCP/IP item, and click ''Properties''<br />[[File:Remote-connections2.png]]<br /><br />
 
#Right-Click on the TCP/IP item, and click ''Properties''<br />[[File:Remote-connections2.png]]<br /><br />
 
#Toggle the ''Enabled'' property to '''Yes'''.<br />[[File:Remote-connections3.png]]<br /><br />
 
#Toggle the ''Enabled'' property to '''Yes'''.<br />[[File:Remote-connections3.png]]<br /><br />
#Switch to the IP Addresses tab, and enable the ports you wish to use to access SQL Server<br />[[File:Remote-connections4.png]]
+
#Switch to the IP Addresses tab, and enable the ports you wish to use to access SQL Server<br />[[File:Remote-connections4.png]]<br /><br />
 +
Restart the SQL Server Service, and you'll be able to connect remotely via IP or hostname.

Revision as of 23:00, 25 November 2012

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 (it may be named Protocols for MSSQLSERVER in some installations.)

  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

Restart the SQL Server Service, and you'll be able to connect remotely via IP or hostname.