Administering a SQL Database Infrastructure — Question 81

You administer two instances of Microsoft SQL Server 2016.
You deploy an application that uses a database on the named instance.
The application is unable to connect to the database on the named instance.
You need to ensure that the application can connect to the named instance.
What should you do?

Answer options

• A. Use the Data Quality Client to configure the application.
• B. Start the SQL Server Browser Service.
• C. Use the Master Data Services Configuration Manager to configure the application.
• D. Start the SQL Server Integration Services Service.

Correct answer: B

Explanation

Starting the SQL Server Browser Service is essential for allowing applications to connect to named instances of SQL Server, as it provides the necessary information about the instances running on the server. The other options do not address the connection issue directly; they pertain to different services or configurations that are not relevant for establishing the connection to the named instance.