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 connect to the named instance.

What should you do?

A. Configure the application as data-tiered.

B. Open port 1433 on the Windows firewall on the server.

C. Configure the named SQL Server instance to use an account that is a member of the Domain Admins group.

D. Start the SQL Server Browser Service.

Explanation:

The SQL Server Browser 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

Connecting to dedicated administrator connection (DAC) endpoints

References: https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx