Provisioning SQL Databases — Question 55

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?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because the SQL Server Browser Service facilitates connections to named instances by providing the necessary port information. Option A is unrelated to connection issues, B may help but is not the primary requirement, and C is unnecessary as SQL Server can operate with standard user accounts.