SQL Server 2005: Day to Day DBA – Part I

I have been thinking about
this series for quite awhile and have decided to start my Day to Day DBA
(DTDDBA). This series will consist of How-To articles from a beginning perspective
and advance as far as I can take it. My goal for this series is to teach you
the basics as well as advanced DBA skills. I imagine that throughout this
process, we will both learn new things as I am writing this series on Microsoft’s
next release of SQL Server 2005. We will begin with a tutorial on how to
install SQL Server 2005 Beta 2 Release.

Installing SQL Server 2005

After kicking off the
executable, you have three options: Prepare, Install, and Other Information. We
will start by choosing Run the SQL Server Installation Wizard (Figure
A.). Next, accept the End User License Agreement (Figure B.) and the installer
checks to make sure your computer meets the criteria to continue the

Figure B.

If it does not meet the criteria, you are presented with the
following screen as shown in Figure C. The following list is required for SQL
Server 2005 to move forward in the installation: .Net Framework 2.0, Microsoft
SQL Native Client, Microsoft SQL Server 2005 Beta 2 Support Files.

Figure C.

At this point, you are taken to the Welcome Screen to begin
the installation as shown in Figure D. Click Next to begin a System
Configuration Check. This part of the install will check for potential problems
(Figure E.) with your system environment. For example, if you are installing
Reporting Services, the System Configuration Check will make sure you have IIS
installed. If you do not, it will come up with a warning.

Figure D.

Figure E.

Once the System Configuration Check is complete, you are
prompted to input your license information and then choose which components you
want installed (Figure F.) For the purposes of this article, I chose to
install all of the components. You can choose Advanced to have a different display
used to choose your components.

Figure F.

Click Next and choose whether you want to install a Default
Instance or a Named Instance as shown in Figure G. On the Service Account
window (Figure H.), define whether you want to install the services as a local
user account or a domain user account.

Figure G.

Figure H.

Steven Warren
Steven Warren
Steven S. Warren is a popular author residing in Winter Haven, Florida with his wife Danna and 2 children: Catie-Charlotte and Dain. As a columnist on such well-known IT web sites as Techrepublic.com, CNET, and ZDNET, Steven has published numerous articles. Additionally, Steven holds the following certifications: MCDBA, MCSE, MCSA, CCA, CIW-SA, CIW-MA, Network+, and I-Net+. As a Senior Technical Consultant for The Ultimate Software Group, Steven has become an expert at administering Microsoft networks including Microsoft SQL Server. He is also a computer hardware and troubleshooting expert, and is constantly seeking out new technologies and certifications. Additionally, Microsoft recently awarded him the Most Valuable Professional (MVP) award for his outstanding achievements. Steven resides in Winter Haven, Fl.

Latest Articles