Exam 70-765 topic 3 question 41 discussion

Actual exam question from Microsoft's 70-765

Question #: 41
Topic #: 3

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.

Show Suggested Answer

Suggested Answer: D 🗳️
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

by Iva10 at Sept. 21, 2020, 12:10 p.m.

Comments

Submit Cancel

Iva10

4 years, 9 months ago

Why not B open port 1433. Application doesn't need SQL browser service to connect, connection string is usually written in config file.

upvoted 1 times

course104

4 years, 5 months ago

because of "two instances"

upvoted 1 times

...