Building a SQL 2005 Database on Windows 2003

Posted on 22. Sep, 2009 by joshhrob in Database

Print This Post Print This Post

VN:F [1.6.3_896]
Rating: 3.0/10 (8 votes cast)

After the system has been updated, Insert SQL 2005 CD disk 1. At the splash screen click on Install “Server Components, tools, Books, Online and Samples”.

SQL-2009-08-29-16-23-06

Check the box stating you accept and press Next

SQL-2009-08-29-16-23-17

In this example, the system does not already have .Net Framework installed. Press the Install button to install the .Net framework from CD. (If you already have .Net Framework this step will be skipped).

SQL-2009-08-29-16-23-27

After .Net Framework installation press Next

SQL-2009-08-29-16-27-43

Press Next to begin SQL install

SQL-2009-08-29-16-28-09

The installer will check your system to make sure you meet the prerequisites. In this case we receive a warning because IIS is not installed and some features will not be available. We don’t care at this point. Press next.

SQL-2009-08-29-16-28-20

Enter serial number and press next

SQL-2009-08-29-16-28-51

Check all boxes, but before continuing press Advanced

SQL-2009-08-29-16-30-52

Change the installation path to Z

SQL-2009-08-29-16-31-42

Select or unselect features. If you are not sure what you need and don’t need you may want to just install everything.

SQL-2009-08-29-16-32-38

Choose default instance

SQL-2009-08-29-16-33-01

Select local system account, and check the box so that SQL Agent is started automatically

SQL-2009-08-29-16-33-38

Select Mixed Mode Authentication and enter a password for the sa account

SQL-2009-08-29-16-34-21

Leave default collation and press next

SQL-2009-08-29-16-34-44

Check boxes if you want to report errors to Microsoft. Otherwise, leave unchecked and press next

SQL-2009-08-29-16-34-56

Press Install

SQL-2009-08-29-16-35-03

Installer runs. When propted, insert disk2

SQL-2009-08-29-16-42-51

When installation is complete press Next

SQL-2009-08-29-16-55-33

VN:F [1.6.3_896]
Rating: 3.0/10 (8 votes cast)

Tags: , ,

Pages: 1 2 3

Print This Post Print This Post

Leave a reply