You install SQL Server on a new server named SQL1 and create several databases.
Users report that they fail to connect to any of the databases on SQL1.
You discover that the TCP connections are disabled for the database engine on SQL1.
You need to ensure that the users can connect to the databases on SQL1.
What should you use?
A. the SQL Server Installation Center
B. the sp_configure stored procedure
C. SQL Server Configuration Manager
D. the ODBC Data Source Administrator
Correct Answer: C
Explanation/Reference:
To enable the TCP/IP network protocol
1. Start SQL Server Configuration Manager. Click Start, point to All Programs, and click Microsoft SQL Server. Click Configuration Tools, and then click SQL Server Configuration Manager.
2. In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration.
3. In the console pane, click Protocols for <instance_name>.
4. In the details pane, right-click TCP/IP, and then click Enable.
5. In the console pane, click SQL Server Services.
6. In the details pane, right-click SQL Server (<instance_name>), and then click Restart, to stop and restart the SQL Server service.
References: https://technet.microsoft.com/en-us/library/hh231672(v=sql.110).aspx
