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

6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P28 PDF 6. - THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P28 PDF
THE REAL MTCS SQL SERVER 2008 EXAM 70 432 PREP KIT P28 PDF
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\PhobosB. Install SQL Server Client Tools on the application server and create a SQL Server Alias called MARS that points to MARS\PhobosC. Install SQL Server Client Tools on the application server and create a SQL Server Alias called MARS\Default that points to MARS\PhobosD. Add a PTR record on your DNS server for MARS that points to MARS\Phobos