PrepAway - Latest Free Exam Questions & Answers

Tag: the instance name is already in use sql 2008

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 and all client computers run Windows XP Professional. The Domain.com network contains two SQL Server 2005 database servers that are configured in a cluster with two nodes named NodeA and NodeB. NodeA hosts a default 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 on NodeA. You need to ensure that all users will be able to connect to the Sales_DB database.
What should you do?