You administer two instances of Microsoft SQL Server 2012.
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 connectto the named instance.
What should you do?
A.
Use the Data Quality Client to configure the application.
B.
Start the SQL Server Browser Service.
C.
Start the SQL Server Integration Services Service.
D.
Use the Master Data Services Configuration Manager to configure the application.
Explanation:
The answer is either start the browser service or use the Master Data Services Configuration Manager to
configure the application. I have left the answer the way I found it.
I am certain that the answer is B. You cannot connect to a named instance by name without the Browser Service running.
Even if you configure the application by running the Master Data Services Configuration Mgr, the application still wouldn’t connect if the SQL Server Browser Service is not started.
Outside of the question:
You don’t need to start Browser Service if you use the port in connection string of the application:
ServerName\InstanceName,port.