Enabling the TCP/IP network protocol in MS SQL Server 2012
- - Windows 7: Go to Start>Run
- Windows 8/8.1: Press the Windows key, type Run and hit Enter
- Type sqlservermanager11.msc and click OK
- Select SQL Server Network Configuration from the left hand pane
- Right click TCP/IP from the right hand pane and select Enable
- Restart MS SQL Service
Enabling the TCP/IP network protocol in MS SQL Server 2008
- - Windows 7: Go to Start>All Programs>Microsoft SQL Server 2008 R2>Configuration Tools>SQL Server Configuration Manager
- Windows 8/8.1: Press the Windows key, type Run and hit Enter and type sqlservermanager11.msc and click OK
- Select SQL Server Network Configuration from the left hand pane
- Right click TCP/IP from the right hand pane and select Enable
- Restart MS SQL Service