You need to ensure that the application can connectto the named instance

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?

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.



Leave a Reply 2

Your email address will not be published. Required fields are marked *


Yommy O.

Yommy O.

The Master Data Services Configuration Manager is used to specify to the Application which database instance to connect to. Since there is a named instance that the Application couldn’t connect to, you need to start the SQL Server Browser Service, as users of the application would require this service to be able to access the DB instance.