You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Windows 2000 domain named Miracle Info.com. All servers on the Miracle Info.com network run on Windows 2000 Server while the client computers run Windows 2000 Professional, Windows 98, and Novell NetWare. All computers are members of the Miracle Info.com domain. The Miracle Info.co m network contains a SQL Server 2000 database server named Miracle Info -DB01 that hosts a default instance of SQL Server 2000. Miracle Info.com wants to implement another SQL Server 2000 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Miracle Info.com users will require access to the Sales_DB database ase. You have been instructed to create the SQL Server 2000 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. Then enable the NWLink IPX/SPX Net-Library for the instance.
B. B.Install the instance as a default instance and configure it to support Windows Authentication. Then enable the TCP/IP Sockets Net-Library for the instance.
C. C.Install the instance as a Named Instance and configure it to support SQL Server Authentication. Then enable the IPX/SPX for the instance.
D. D.Install the instance as a default instance and configure it to support Windows Authentication. Then enable the TCP/IP Sockets Net-Library for the instance.
Answer:A
You work as the database administrator at Miracle Info.com. The Miracle Info.com network consists of a single Windows 2000 domain named Miracle Info.com. All servers on the Miracle Info.com network run on Windows 2000 Server while the client computers run Windows 2000 Professional, Windows 98, and Novell NetWare. All computers are members of the Miracle Info.com domain. The Miracle Info.co m network contains a SQL Server 2000 database server named Miracle Info -DB01 that hosts a default instance of SQL Server 2000. Miracle Info.com wants to implement another SQL Server 2000 instance for a database named Sales_DB. Sales_DB will store sales data for the company. All Miracle Info.com users will require access to the Sales_DB database ase. You have been instructed to create the SQL Server 2000 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. Then enable the NWLink IPX/SPX Net-Library for the instance. B. B.Install the instance as a default instance and configure it to support Windows Authentication. Then enable the TCP/IP Sockets Net-Library for the instance. C. C.Install the instance as a Named Instance and configure it to support SQL Server Authentication. Then enable the IPX/SPX for the instance. D. D.Install the instance as a default instance and configure it to support Windows Authentication. Then enable the TCP/IP Sockets Net-Library for the instance.