Administering Microsoft SQL Server 2012/2014 Databases — Question 53

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?

Answer options

• A. the SQL Server Installation Center
• B. the sp_configure stored procedure
• C. SQL Server Configuration Manager
• D. the ODBC Data Source Administrator C

Correct answer:

Explanation

The correct answer is C, SQL Server Configuration Manager, as it allows you to enable TCP/IP connections for SQL Server, thereby allowing user access to the databases. While A and B are valuable tools for installation and configuration settings, they do not specifically manage network protocols. Option D, the ODBC Data Source Administrator, is used for configuring ODBC connections, but it does not control TCP settings for SQL Server.