You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003. The Domain.com network contains a Domain Controller named Certkiller -DC01 and a member server named Certkiller -SR21.
Domain.com wants to implement a SQL Server 2005 database that will store sales data. All Domain.com users will require access to the Sales_DB database. You have been instructed to install SQL Server 2005 on Certkiller -SR21 and to create a database named Sales_DB. You need to ensure that Domain.com users and applications can connect to the database instance by using only the computer name. What should you do during the installation of SQL Server 2005 on CERTKILLER-SR21?
A.
Select the Named Instance and use MSSQLSERVER as the instance name.
B.
Select the Named Instance and use Certkiller -DC01 as the instance name.
C.
Select the Default Instance and accept the default instance name.
D.
Select the Named Instance and use Certkiller -SR21 as the instance name.
Explanation:
To ensure that users and applications can connect to the instance using the computer name, you should select the Default Instance and accept the default instance name, MSSQLSERVER.
Incorrect Answers:
A, B, D: You cannot use a Named Instance as users and applications will need to specify the server name and the instance name when connection to the database.