SQL Server 2005: Day to Day DBA - Part I

Wednesday Dec 29th 2004 by Steven Warren

Steven Warren begins a series of How-To articles for SQL Server 2005. The first installment of this series examines how to install SQL Server 2005 Beta 2 Release.

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.

On the Authentication mode window (Figure I), choose whether you want to configure SQL Server 2005 as Windows Authentication only or Mixed Mode. If you choose Mixed Mode, you must assign a strong sa password as shown in Figure I. On the Collation Settings window, accept the defaults unless you have specific collation requirements for your company (Figure J).

Click for larger image

Figure I.

Click for larger image

Figure J.

If you are installing Reporting Services, specify the Report Server virtual directory and the Report Manager virtual directory as shown in Figure K. On the Report Server Database Setup, choose the appropriate instance that you want the Reporting Server installed on (see Figure L) as well as the Report Server database name.

Figure K.

Figure L.

On the Report Server Delivery Settings window, enter the appropriate SMTP setting as shown in Figure M and decide in the Error Reporting window (Figure N.) whether you want to automatically send fatal error reports to Microsoft.

Figure M.

Figure N.

On the Ready to Install window, review your components and click install as shown in Figure O. You are now presented with a Setup progress window (see Figure P.) and when all components are installed, click Next. Figure Q. displays the final window with a link to a Summary Log. Click Finish. In my next article, we will go over the new interface of SQL 2005 and see what it has to offer.

» See All Articles by Columnist Steven S. Warren

Mobile Site | Full Site