SQL Server™ 2005 Bible

Chapter 4. Installing SQL Server 2005

In This Chapter

• Planning an installation

• Server-hardware recommendations

• Performing the installation

• Installing multiple instances of SQL Server

• Upgrading from previous versions of SQL Server

• Migrating to SQL Server

• Configuring the surface area of SQL Server

While the actual act of installing SQL Server is relatively easy, knowing the intended users, environment, and uses that the database must meet may not be quite so clear. Additional time spent identifying and answering these and other questions about the environment and use will pay off with a smoother installation.

Although this chapter focuses on the aspects of installing a new SQL Server, some information will be provided on upgrading to SQL Server.

Note

SQL Server 2005 can be used alongside existing SQL Server installations.

Planning Your Installation

Give some thought to the server's hardware. Consider user accounts, including SQL Server's disk configuration, collations, and client access. If a server is being upgraded, take advantage of the Upgrade Advisor Tool, discussed later in this chapter.

Operating System

SQL Server 2005 installs and runs on various operating systems—from Windows XP Home to Windows Server 2003 Enterprise Edition, with the more feature-rich versions running on the higher-end operating systems. Table 4-1 illustrates which editions of SQL Server are compatible with which operating systems.

Security Accounts

Accessing SQL Server requires that a user have an appropriate account for ...