YOU HAVE JUST UPGRADED YOUR DATABASES FROM A SQL SERVER 2005 DEFAUL...

6. You have just upgraded your databases from a SQL Server 2005 default

instance to a SQL Server 2008 named instance called Phobos on a server

named MARS. The application that uses the SQL Server sits on its own server,

and you’ve just found out that you can’t change the connection string in the

application to point to the new instance. How can you fix it?

A. Add a CNAME record on your DNS server for MARS that points to

MARS\Phobos

B. Install SQL Server Client Tools on the application server and create a SQL

Server Alias called MARS that points to MARS\Phobos

C. Install SQL Server Client Tools on the application server and create a SQL

Server Alias called MARS\Default that points to MARS\Phobos

D. Add a PTR record on your DNS server for MARS that points to MARS\

Phobos

Correct Answer & Explanation: B. Connection requests from the application

to MARS will be redirected to MARS\Phobos without you having to change

the connection string.

Incorrect Answers & Explanations: A, C, D. Answer A is incorrect because

DNS resolves IP addresses, and you still need to connect to same server

(MARS). DNS has no awareness of instances. Answer C is incorrect because

you connect to a default instance using the servername, not servername\

Default. Answer D is incorrect because DNS resolves IP addresses, and

you still need to connect to same server (MARS). DNS has no awareness

of instances.