Difference between revisions of "MS SQL Server FAQs"
From Hostek.com Wiki
(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:
- Open the SQL Server Configuration Manager
- Expand the SQL Server Network Configuration-->Protocols for SQLEXPRESS section (it may be named Protocols for MSSQLSERVER in some installations.)
- Right-Click on the TCP/IP item, and click Properties
- Toggle the Enabled property to Yes.
- Switch to the IP Addresses tab, and enable the ports you wish to use to access SQL Server
Restart the SQL Server Service, and you'll be able to connect remotely via IP or hostname.