Microsoft SQL Server 2005 deployment walkthrough

By Bill Detwiler July 26, 2006, 4:02 AM PDT billdetwiler

Image
1
of 6

Microsoft SQL Server 2005 deployment walkthrough

System check

After the prerequisites install on your system, the SQL Server 2005 installation wizard starts. The first task completed by the wizard is a scan of your system to make sure it meets the minimum requirements for SQL Server 2005.

Here you see two areas of concern noted by the system check. The first is the minimum hardware requirement. This is showing up because I’ve assigned only 384MB of RAM to the virtual machine running SQL Server 2005 on my system, which can be easily fixed. The second, IIS Feature Requirement, is a little more serious. A few SQL Server 2005 services, such as Reporting Services, require IIS. So, before I move forward, I’m going to quit the installation of SQL Server 2005 and install IIS on my server. After that, I’ll continue with the installation.

Feature selection

Here you see the Advanced screen. In either window, click Next to continue with the installation.

RS Installation options

If you chose to install Reporting Services, you have two installation options on the next screen. First, you can install Reporting Services with default options, or you can choose to install without configuring it. I’m going to install Reporting Services with the default options.

RS Defaults

These are the default options for Reporting Services.

Error usage settings

A new option in SQL Server 2005 allows you to share errors and usage information with Microsoft. The disclaimer indicates that personal information may incidentally be sent to Microsoft but won’t be used for anything. It’s up to you to decide whether or not you believe it.

Setup progress

The Setup Progress window keeps you apprised of exactly where the installer is with regard to each individual component.

This was a fairly simple overview of the SQL Server 2005 installation process and is not designed to show every possible installation scenario, but rather to give you a look at the overall process to help you plan your own installation.

By Bill Detwiler

Bill Detwiler is the Editor for Technical Content and Ecosystem at Celonis. He is the former Editor in Chief of TechRepublic and previous host of TechRepublic's Dynamic Developer podcast and Cracking Open, CNET and TechRepublic's popular online show.

Account Information

Contact Bill Detwiler

Your message has been sent
|
See all of Bill's content

This policy describes guidelines your organization can follow to track, process and decommission IT equipment. From the policy: SUMMARY An organization’s IT hardware inventory constitutes a significant capital investment in order to perform company operations. Because hardware represents a critical asset and often holds organizational data, it is important for the company to track each ...

Whether an infection is the result of a disgruntled employee, hardware vulnerability, software-based threat, social engineering penetration, robotic attack or human error, all organizations must be prepared to immediately respond effectively to such an issue if the corresponding damage is to be minimized. Because even the best protected networks become infected, all organizations must have ...

Every operating system should be appropriately secured, especially end user workstations which often contain or permit access to company data and upon which most employee job duties are based. To get the maximum security protection out of your Windows 10 deployments follow this checklist from TechRepublic Premium. Also included in this checklist: Security solutions Product ...