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

Cybersecurity demands and the stakes of failing to properly secure systems and networks are high. While every organization’s specific security needs form a unique and complex blend of interconnected requirements, numerous security fundamentals almost always apply to each of these groups. It stands to reason that cybersecurity pros who effectively identify network and systems risks ...

In this guide from TechRepublic Premium we’re going to explore the various things you can do with a Linux server. We won’t leave out any steps, so you won’t have to refer to another tutorial to complete the process. The only step we will leave out is the installation of Linux, as we’ll assume you ...

If you want to deploy applications into a Kubernetes cluster, be warned — it’s not the easiest task. There are a lot of moving pieces that go into these scalable containers. Don’t you wish you had a complete roadmap, from start to finish, to walk you through the process of deploying the Kubernetes cluster, deploying ...