Configuring the SQL Server network
After installing the SQL Server 2012 database, you must configure the SQL Server network to ensure that eSight can access the database.
Prerequisites
You have installed the Microsoft SQL Server 2012 database.
Procedure
- Choose Start > Microsoft SQL Server 2012 > Sql Server Configuration Manager.
The Sql Server Configuration Manager window is displayed.
- Choose SQL Server Network Configuration > Protocols for MSSQLSERVER, right-click TCP/IP, and choose Enable.
- Right-click TCP/IP and choose Properties from the shortcut menu. In the TCP/IP Properties window that is displayed, configure the SQL network.
- On the Protocol tab page, set Listen All to No.
- On the IP Addresses tab page, set Enabled to Yes for 127.0.0.1. For other IP addresses, retain the default value No for Enabled.
- Click OK.
- On the Protocol tab page, set Listen All to No.
- Restart the SQL Server database service to make the configuration take effect.