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 on Windows Server2003 while the client computers run Windows XP Professional, Windows 98 Second Edition, and Novell NetWare 6.5. All computers are members of the Domain.com Active Directory domain. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database instance named MSSQLSERVR. Domain.com wants to implement another SQL Server 2005 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Domain.com users will require access to the Sales_DB database. You have been instructed to create the SQL Server 2005 instance for the Sales_DB database. You need to ensure that all users will be able to connect to the Sales_DB database. You cannot make configuration changes to the client computers. Your solution must optimize network traffic.
What should you do?
A.
Install the instance as a Named Instance and configure it to support Mixed Mode Authentication. The enable TCP/IP for the instance.
B.
Install the instance as a Default Instance and configure it to support Windows Authentication. The enable TCP/IP for the instance.
C.
Install the instance as a Named Instance and configure it to support SQL Authentication. The enable IPX/SPX for the instance.
D.
Install the instance as a Default Instance and configure it to support Windows Authentication. The enable IPX/SPX for the instance.
Explanation:
The default instance is named MSSQLSERVER. This instance name is already in use; therefore you should use a Named Instance. You should use Mixed Mode Authentication to support NetWare users.
Incorrect Answers:
B: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is already in use. Furthermore, you need to use Mixed Mode Authentication as Windows Authentication does not support NetWare users.
C: You can use SQL Authentication, but this will require that you create SQL Logins for all users and groups. It would be easier to use Windows Authentication for clients that user Windows XP Professional and Windows 98 SE, and create SQL Logins for the NetWare 6.5 users. Also, SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.
D: You cannot use the Default Instance as the default instance is named MSSQLSERVER and is already in use. Furthermore, you need to use Mixed Mode Authentication as Windows Authentication does not support NetWare users. Also, SQL Server 2005 does not support IPX/SPX. The newer versions of NetWare, such as NetWare 6.5, support TCP/IP which makes it the common protocol for all clients.