What should you do?

You work as a database administrator at Domain.com. Domain.com contains a SQL Server
2008 computer named CERTKILLER-DB01. CERTKILLER-DB01 contains three examples of SQL
Server that is supposed to have the ability to connect to the dedicated administrative connection to
have a disaster recovery plan. During testing you can connect to the connection on CERTKILLER-DB01’s
default example to test its ability; however, you cannot connect to the dedicated
connection on the two other examples. You have received instructions to do the following:
* Make sure that the examples are implementing.
* Make sure that the client applications can approach them.
* Ensure that the other administrators cannot connect to any dedicated connections on CERTKILLER-DB01.
* Ensure that you could connect to the dedicated connection on all three examples.

What should you do?

You work as a database administrator at Domain.com. Domain.com contains a SQL Server
2008 computer named CERTKILLER-DB01. CERTKILLER-DB01 contains three examples of SQL
Server that is supposed to have the ability to connect to the dedicated administrative connection to
have a disaster recovery plan. During testing you can connect to the connection on CERTKILLER-DB01’s
default example to test its ability; however, you cannot connect to the dedicated
connection on the two other examples. You have received instructions to do the following:
* Make sure that the examples are implementing.
* Make sure that the client applications can approach them.
* Ensure that the other administrators cannot connect to any dedicated connections on CERTKILLER-DB01.
* Ensure that you could connect to the dedicated connection on all three examples.

What should you do?

A.
You should consider rebooting the default examples of SQL Server.

B.
You should consider resetting the default example and not use port 1434.

C.
You should consider using the IIS tool to make the dedicated administrative connection.

D.
You should consider starting the SQL Server Browser service and set is to run automatically.



Leave a Reply 0

Your email address will not be published. Required fields are marked *