PrepAway - Latest Free Exam Questions & Answers

You administer two instances of Microsoft SQL Server 2016.

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 in

stance.

What should you do?

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 Ser

vices Service.

The SQL ServerBrowser program runs as a Windows service. SQL Server Browser listens for incoming requests for Microsoft SQL Server resources and provides information about SQL Server instances installed on the computer. SQL Server

Browser contributes to the following actions:

Browsing a list of available servers

Connecting to the correct server instance

Etc.

References: https://docs.microsoft.com/en-us/sql/tools/configuration-manager/sql-server-browser-service


Leave a Reply