SQL Server 2005 DBA

Phase 1

Installing and Configuring Microsoft SQL Server 2005

F I G U R E 1 . 1

Check SQL Server Configuration Manager to see whether your services are

running after installation.

Task 1.2: Installing a Second Instance

Using a technique called

instancing

, you can have more than one copy of SQL Server 2005
running on the same computer at the same time. Each instance has its own set of system
databases and its own security system in place. This is useful if you need a server for pro-
duction and another for testing but you do not have enough hardware for two separate
physical machines or you need to have two or more systems with disparate security settings.
Throughout this book, you will be using a named instance in order to get some practice with
the more advanced features of SQL Server 2005 (such as replication). In this task, you will
install a second instance of SQL Server 2005 on the same machine as the default instance.

Scenario

You are the database administrator (DBA) for a midsize company with offices in various cities
throughout the United States and Canada. You know you need an instance of SQL Server
2005 for testing new service packs, new database schemas, and the like, but your company
does not have the budget for new hardware at this time. The only way for you to have a test
copy of SQL Server is to install a named instance.