how can I install SQL server 2005 SP2 standard edition in Windows Server 2008

[anyweb]

This guides main purpose is to help you install SQL 2005 SP2 standard edition on Windows Server 2008 (while we wait for SQL 2008).

 

Part 1. Install SQL Server 2005 standard edition

 

The screenshots for this guide were taken from a Windows Server 2008 which had been preinstalled and configured with AD, DHCP, DNS, WDS

 

Insert the Microsoft SQL Server 2005 Standard Edition DVD (or mount the ISO available on MSDN called en_sql_2005_std_x86_dvd.iso) using Daemon tools or similar.

 

When the splash screen appears, choose the Server components, tools, Books Online, and Samples choice under the Install menu.

 

 

depening on your version of Windows Server, you may get a warning about known combatibility issues as below, but that's safe to ignore as we will be upgrading this install to Service Pack 2 as part of the process.

 

 

Click on Run program and accept the licensing aggreement...

 

 

you'll be informed that setup has to install some prerequisites (Microsoft SQL Native Client and Microsoft SQL Server 2005 Setup Support Files)

 

click install to continue

 

 

once installed click next to continue

 

 

next you'll see a window system configuration check, but behind it is the actual SQL Server Setup Wizard,

 

 

 

in the Welcome to the Microsoft SQL Server installation Wizard, click next

 

if you get a warning that IIS is not installed, ignore it for now as we will install it later.

 

 

- IIS Feature Requirement (Warning)

Messages

IIS Feature Requirement

 

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

 

If you get the IIS warning, click next to continue then cancel out of the SQL setup and follow this guide to install IIS 7 in Windows Server 2008

 

Once you have IIS installed, re-run the Microsoft SQL Server installation Wizard. If you get the IIS error again, ignore it and click next to continue

 

review the registration info and click next to continue

 

 

in the components to install screen select all options

 

 

click next to continue and choose Default Instance

 

 

on the next screen enter your administrator password for the SQL Server Service,

 

 

click next and note the warning, for the remaining services we will use the local system account

 

 

select local system account for the remaining services like this (you'll see the above warning each time until all three are configured to use the local system account.... namely SQL Server Agent, Analysis Services and SQL Browser

 

 

leave the authentication mode as it is (Windows Authentication Mode)

 

 

set the collation settings as follows

 

 

leave the Error and Usage report settings as they are and click next...

 

 

review the summary

 

 

and click Install to continue

 

this will take some time, so now is a good time for a coffee break...

 

 

after a long time you may see the following Visual Studio 2005 warning, click on Run Program to continue

 

 

we can resolve it later by doing as quoted here

 

Download updates for Visual Studio 2005

 

This problem was caused by a compatibility issue between this version of Windows and this version of Visual Studio 2005. This program was created by Microsoft.

 

Solution

 

--------------------------------------------------------------------------------

 

 

To solve this problem, go online and install the following updates:

 

Visual Studio 2005 Service Pack 1

Visual Studio 2005 Service Pack 1 Update for Windows Vista

 

however, as we will be upgrading SQL 2005 to SQL 2005 SP2, we will ignore this for now...

 

when the Setup Progess is done, click on next

 

 

review the summary

 

 

and click finish and then reboot the server.

[shaik.basheeruddin]

Your website is very useful to me. Thank you very much

 

I want to install sccm 2007 sp1 on windows server 2008 x64 (not R2) enterprise edition. I followed all your steps. During the wsus installation, Use an existing database server on this computer greyed out, that is not highlighted. I am using sql server 2005 sp2, 32-bit, wsus 3.0 sp1 64-bit. Kindly, help me, I searched a lot in google, couldnt find the solution, kindly help me.