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
https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx