Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Dec 29, 2004

SQL Server 2005: Day to Day DBA - Part I

By Steven Warren

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.

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM