Windows Server Longhorn (2008) Beta 3 – Installing SQL Server 2005

Posted on June 3rd, 2007 by Mark Sheppard

If you want to install SQL Server 2005 on Windows Server 2008 (formally Longhorn server), you need to be aware of the process.

Note: This was worked out on Windows Server Longhorn Beta 3 (build 6001), so procedures may change by the time Windows Server 2008 RTM’s.

Prerequisites

If you’re planning on installing SQL Reporting on Windows Server 2008, you need to add the IIS Role through server manager and you need the following service components installed:

  • Common HTTP Features
    • Static Content
    • Default Document
    • HTTP Redirection
    • Directory Browsing
  • Application Development
    • ASP.Net
    • ISAPI Extension
    • ISAPI Filters
  • Security
    • Windows Authentication
  • Management Tools
    • IIS Metabase
    • IIS 6 WMI

For more information I suggest that you read William Li’s blog post on the subject. It’s referring to an older version of Longhorn Server, but is still pretty sound.

Installation

Installing SQL Server 2005 is a little painful now-a-days; the process goes like this if you do a complete install like I did:

  1. Install SQL Server 2005 - Click “Run Program” to every prompt (a total of three for my install. 2 for SQL and 1 for Visual Studio because it’s installed as part of the client install)
  2. Install SQL Server 2005 Service Pack 2 (KB921896)
  3. Install SQL Server 2005 post SP2 hot fix rollup (KB933508)

Click here to continue reading Windows Server Longhorn (2008) Beta 3 – Installing SQL Server 2005.

No Comments »
Filed under: SQL Server 2005, Windows Server 2008