View source for MS SQL Server FAQs

==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:
#Open the SQL Server Configuration Manager<br />[[File:Remote-connections1.png]]<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 />
#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]]<br /><br />
Restart the SQL Server Service, and you'll be able to connect remotely via IP or hostname.