SQL Server 2005: Day to Day DBA - Part I

December 29, 2004

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 installation.

Click for larger image

Figure A.

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.