SQL Server 2005 Installation Issues
Whether you are installing SQL Server Express Edition on your personal notebook or SQL Server Enterprise Edition on a 32-processor 50-node cluster environment, a smooth installation of SQL Server requires an installation plan. The scope and number of tasks in your installation plan size depends on the size and complexity of your hardware and application, but at a minimum, you need to plan for three types of installation tasks:
Although installation planning for the large IT organization is beyond the scope of this book, we briefly state the pre-installation tasks and go through the steps for installation.
Prior to the installation of SQL Server on a computer, we suggest you make a checklist of items to ensure a successful installation.
Choosing the Right SQL Server Edition
As we mentioned before, SQL Server is a collection of components, and each component has a number of features to support various aspects of a database application. Microsoft has bundled these components and features into various editions to better accommodate system capacity, performance, and the price requirements of its customers. Prior to acquiring and installing SQL Server, you should study all editions of SQL Server to find the best match for your application and business needs.
As stated in Table 2.1, SQL Server has several different editions, each packaged with different components and functionality. One of your main decisions before any installation of SQL Server should be selecting the edition that suits your personal or business needs. In a large organization, the selection process should include both the database and business stakeholders such as database administrators, database developers, and business unit owners. Everyone should carefully review the functionality of each of edition of SQL Server 2005 to determine which functionality matches the business's current and future needs. This review process should also include an audit of the existing functionality, determination of immediate future functionality, and consultation with business units on functionality needed to support their goals in the next 23 years. After compiling a listing of required functionality, the database administrator should match the required functionality with the SQL Server functionality provided in each edition.
Understanding SQL Server Instances
Prior to the installation of SQL Server, it is important that you understand the significance of SQL Server instances because the installation is instance-based. A computer can run multiple instances of SQL Server simultaneously, and each instance runs independently of other instances. A server can have only one default instance of SQL Server, but multiple named instances up to the resources available on the computer. SQL Server 2005 supports multiple instances on a single server. However, not all SQL Server components are instance-aware. Table 2-2 describes components that are instance aware.
The maximum number of instances supported in SQL Server 2005 is based on the editions and cluster configuration of your system, as described in Table 2-3.
Each instance of SQL Server is made up of a distinct set of services with separate settings for collations and other options. The directory structure, Registry structure, and service names all reflect the specific instance name that you specify during the installation of an instance. A SQL Server instance can be either the default instance or a named instance. Although you can technically configure up to 50 instances of SQL Server on a computer, in reality the maximum number of instances you can deploy depends upon the hardware resources available.
A named instance can be installed either as the first or only instance, or in a subsequent installation of SQL Server. The first time you install SQL Server on a computer with no existing installations of SQL Server, the installation program assumes installation of the default instance, although you can choose to install SQL Server as a named instance without installing the default instance first.
SQL Server Installation Tool
SQL Server 2005 has a new installation tool called SQL Server 2005 Setup. The Setup tool can be launched in two ways: through a wizard and in the command line. The Setup Wizard provides a graphical user interface, which guides the user through the installation process. The Setup command line tool is executed from a Windows command prompt and it has several advanced installation options such as remote installation. The Setup command line is more suitable for large enterprise installations. Both the Setup wizard and the command tool provide an integrated solution for installing and upgrading all components of SQL Server.
SQL Server Setup Wizard
The Setup Wizard is an integrated graphical tool for installation and upgrade of all SQL Server 2005 components, namely,