Jump to content


  • 0
anyweb

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

Question

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.

 

splash.jpg

 

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.

 

known_issues.jpg

 

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

 

eula.jpg

 

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

 

prerequisites.jpg

 

once installed click next to continue

 

prerequisites_done.jpg

 

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

 

hidden_window.jpg

 

 

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_not_installed.jpg

 

- 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

 

registration.jpg

 

in the components to install screen select all options

 

options.jpg

 

click next to continue and choose Default Instance

 

default_instance.jpg

 

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

 

domain_user_account.jpg

 

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

 

domain_user_account_warning.jpg

 

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

 

local_service.jpg

 

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

 

windows_authentication.jpg

 

set the collation settings as follows

 

collation_settings.jpg

 

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

 

error_and_usage.jpg

 

review the summary

 

summary.jpg

 

and click Install to continue

 

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

 

installing.jpg

 

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

 

visual_studio.jpg

 

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

 

setup_done.jpg

 

review the summary

 

setup_done_summary.jpg

 

and click finish and then reboot the server.

Share this post


Link to post
Share on other sites

Recommended Posts

  • 0

Part 2. Install the Visual Studio 2005 update for Windows Server 2008

 

do this

 

Part 3. Apply SQL Server 2005 Service pack 2

 

locate your SQL Server 2005 SP2 cd (or iso, the iso from MSDN is called en_sql_server_2005_sp2_x86_cd.iso)

 

Once you've inserted (or mounted the iso) run the SQLServer2005SP2-KB921896-x86-ENU file. This will extract files to a temporary directory for the installation.

 

After some time, a welcome screen will appear

 

 

welcome.jpg

 

click next to start the process

 

accept the EULA

 

eula.jpg

 

leave the features as they are

 

features.jpg

 

leave the Windows Authentication as it is, you can click on the Test button if you want to verify that its ok, it shoul;d say success.

 

authentication.jpg

 

skip the Error usage and reporting screen (don't bother selecting them, just click next)

 

after which a Running Processes window will appear, if locked files are found a reboot will be required (this is ok)

 

locled_files_found.jpg

 

click next and at the ready to install screen, click Install.

 

install.jpg

 

This will take some time so you can take another coffee break now...

 

in_progress.jpg

 

once the components are installed we'll be told it's all complete, click next

 

sp2_complete.jpg

 

 

once done we'll be asked to reboot

 

reboot.jpg

 

click OK followed by next and read the installation complete summary

 

installation_complete_summary.jpg

 

you will get an additional information screen about Windows Vista users, so leave it as default and click Finish.

 

provisioning.jpg

 

When the SQL Server 2005 User Provisioning tool appears, press the two right arrows marked below to mvoe all privileges from the left pane to the right

 

provisioning_tool.jpg

 

click OK when done, that's it.

 

If you get an sqlprov object reference not set to an instance of an object error then reboot and start the sp2 upgrade again.

Share this post


Link to post
Share on other sites

  • 0

Hi,

 

I am trying to install SQL Server 2008 on a Windows 2008 SP2 Server with AD, DHCP and IIS configured. When I run System Configuration Checker from SQL server 2008 setup program, I am seeing a warning on "Computer Domain Controller". And that warning says " Rule "Computer domain controller" generated a warning. Installing SQL Server 2008 on a domain controller is not recommended.

 

Could someone let me know whether this will cause any issues. I could not find any clue for fixing this. Please let me know if there is any fix for this?

 

Thanks

Share this post


Link to post
Share on other sites

  • 0

are you setting this up in a lab environment, if so go ahead,

 

in a production environment you really should separate the roles, ie: have AD on one server, SCCM on another etc.... however Technet does recommend having SQL and SCCM on the same server. See this link > http://technet.microsoft.com/en-ca/library/bb735870.aspx

 

Best Practices for SQL Server

 

 

□ Use a dedicated SQL Server for each site

 

□ Do not use the Configuration Manager site database server to run other SQL Server applications

 

□ Configure SQL Server to use Windows authentication

 

□ Install Configuration Manager and SQL Server on the same computer

Share this post


Link to post
Share on other sites

  • 0

Hi

I'm installing sccm 2007 R2 on Win 2008 Std 64 bit

I have some quotations

1- On TechNet the win 2008 64 bit is acceptable O.S. for SCCM 2007 but is SQl 2005 sp2 std 64 bit available ? I can't find it

2- when trying to install SQl 2005 sp2 std 32 bit the System Configuration Check gives this worning :

ASP.Net Version Registration Requirement (Warning)Messages

ASP.Net Version Registration Requirement

64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

 

Thanks

Share this post


Link to post
Share on other sites

  • 0

hi there

1- On TechNet the win 2008 64 bit is acceptable O.S. for SCCM 2007 but is SQl 2005 sp2 std 64 bit available ? I can't find it

 

its there too, you need to look harder, I'm using sql 2005 sp3 on my home SCCM lab (windows 2008 sp1 x64)

 

don't install the 32 bit version of SQL, get the x64 bit version instead

 

i've just checked technet and its there

 

SQL Server 2005 Enterprise Edition - 64-bit Extended - CD1 (English)

 

Includes: Enterprise; 12-22-2005

Details

Keys

Download

442.23 (MB)

 

 

SQL Server 2005 Enterprise Edition - 64-bit Extended - CD2 (English)

 

Includes: Enterprise; 12-22-2005

Details

Keys

Download

565.18 (MB)

 

and

 

SQL Server 2005 Standard Edition - 64-bit Extended - CD1 (English)

 

Includes: Standard; 12-22-2005

Details

Keys

Download

442.23 (MB)

 

 

SQL Server 2005 Standard Edition - 64-bit Extended - CD2 (English)

 

Includes: Standard; 12-22-2005

Details

Keys

Download

565.18 (MB)

 

 

SQL Server 2005 Standard Edition - 64-bit Extended - DVD (English)

 

Includes: Standard; 12-15-2005

Details

Keys

Download

935.43 (MB)

Share this post


Link to post
Share on other sites

  • 0

Add SP3

 

SP3 is available, read about it here

 

Download and install it, then reboot, and install the Cumulative Hotfix 1 pack.

 

 

Why do we need to add the Cumulative Hotfix 1 pack? We are only suppose to apply these Hotfix packs if we are having issues?

Share this post


Link to post
Share on other sites

  • 0

yeah thats true, but as per http://support.microsoft.com/kb/959195

 

there are a few memory handling issues when using the reporting services and stored proceedures... we just updated a client to SP3 and had to apply this as the SQL Cluster was failing over to often to the offsite cluster. Performance hit was larger than expected so hotfix here we come :-)

 

 

check out the hotfixes included, if you use the function consider the updates

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.