PrepAway - Latest Free Exam Questions & Answers

Tag: sql server 2005 named instance mixed mode

What should you do?

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?