Pre-requisites for installing of SQL Server 2008 on Windows Server 2008 R2

In order for you to begin installing SQL Server 2008 on Windows Server 2008 R2, you will need to add required Server Roles and Features.


First, add the .NET Framework v3.5.1 that SQL Server 2008 requires. Go to the Server Manager –> Features and select add features.

Select .NET Framework 3.5.1 Features in the Add Features dialog

Put a check in the .NET Framework 3.5.1. Features.”. That will pop up a new dialog that says that it will also install some additional roles and features, such as the Web Server (IIS). That is fine, since you will need them anyway.

Add the Required Role Services

Click “Add Required Role Services”.

.NET Framework 3.5.1 Features selected.

Click Next.

Introduction to Web Server (IIS)

Click Next.

Put a check in the Box Common HTTP Features, which will select :

  • Static Content
  • Default Document
  • Directory Browsing
  • HTTP Errors
  • HTTP Redirection

In the Application Development check the  following:

  • .NET Extensibility
  • ISAPI Extensions
  • ISAPI Filters

In the Security, check these:

  • Basic Authentication (Optional)
  • Windows Authentication
  • Client Certificate Mapping Authentication (Optional)
  • IIS Client Certificate Mapping Authentication (Optional)
  • Request Filtering

In the Performance, check these:

  • Static Content Compression (Optional)
  • Dynamic Content Compression (Optional)

In the Management Tools, check the following:

  • IIS Management Console
  • IIS 6 Management Compatibility (Optional)
  • IIS 6 Metabase Compatibility (Optional)
  • IIS 6 WMI Compatibility
  • IIS 6 Scripting Tools
  • IIS 6 Management Console


Web Server services part 1

Web Server services part 2

Click Next.

Confirm Installation screen

Click Install.


When finished

Installation Results screen

Click Close.

How to install MOSS on Windows Server 2008 R2

First a disclaimer. Microsoft doesn’t support this scenario, so you will be on your own.

When you try to install MOSS 2007 on Windows Server 2008 R2, you will be prompted by this error message:


and you are stuck.

The only way to install MOSS 2007 on Windows Server 2008 R2 is to slipstream MOSS Service Pack 2 into the installation media. I will now run through the steps to do so.


  • MOSS 2007 installation media. (Either the .iso file from MSDN, or the DVD)
  • WSS 3.0 Service Pack 2 (Remember to get the x64 version, since Windows 2008 R2 is 64bit only)
  • MOSS 2007 Service Pack 2 (Remember to get the x64 version, since Windows 2008 R2 is 64bit only)

First, extract the contents of your MOSS 2007 media .iso file (or simply copy the files if you are using the DVD) to a temporary installation folder. In my case this will be H:\MOSS Installation Media. There is an TechNet article on how to slipstream updates into MOSS, but I will go through the steps here also.

Open a command prompt and change directory to where you have the service pack files. Extract the contents to the Updates folder of your installation folder.

First the WSS Service Pack files:

officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:"H:\MOSS Installation Media\x64\Updates"

Then the MOSS 2007 service pack files:


officeserver2007sp2-kb953334-x64-fullfile-en-us.exe /extract:"H:\MOSS Installation Media\x64\Updates"


Now, you will need to delete the file wsssetup.dll from the Updated folder, otherwise it will only install the WSS SP2.

You can now install WSS 3.0 and MOSS 2007 SP2 using set setup.cmd found in the installation folder.

How to install the Microsoft Loopback adapter in Windows 7

Microsoft Loopback adapter

For some reason, the Add New Hardware wizard is missing the Microsoft Loopback adapter in the Control Panel in the Beta build of Windows 7 (build 7000). That makes it rather hard to install the loopback adapter. However, you can actually still start the wizard following these instructions.

Click on the Windows Orb (The old Start button) or press the WIN key.


Type hdwwiz.


Click Next

Screenshot Microsoft Loopback adapter

Select the Install the hardware that I manually select from a list (Advanced) option and click Next.



Select Network Adapters and click Next

Screenshot adapter

Select Microsoft and the Microsoft Loopback Adapter and click Next.

Screenshot adapter

Click Next and you are done.

IIs requirements for installing SQL Server 2005/8 on Windows Vista or Windows 7

In order to install SQL Server 2005 or SQL Server 2008, some IIs features must be installed on Windows Vista.

First, install IIs 7 using the following steps:

  1. Start
  2. Control Panel
  3. Programs
  4. Programs and Features
  5. Turn Windows features on or off
  6. Enable <Internet Information services>

Select these features:

  • Web management tools:
    — IIS 6 Management Compatibility
    —- IIS 6 WMI Compatibility
    —- IIS Metabase and IIS 6 configuration compatibility
  • World Wide Web Services
    — Application Development Features
    — ASP.NET
    — ISAPI Extensions
    — ISAPI Filters
  • Common Http Features
    — Default Document
    — Directory Browsing
    — HTTP Redirection
    — Static Content
  • Security
    — Windows Authentication


CATALYST install manager has stopped working

CATALYST install manager has stopped working

On my desktop PC, I have an ATI graphics card and Windows Vista Ultimate 64bit. For the good part of the last 12 months of new ATI drivers, this error: CATALYST install manager has stopped working,  has plagued me when I have tried to install new updated drivers.

I have finally found a solution to get rid of this error. Here are the steps:

Warning! Do this at your own risk, I can’t held responsible for if this works on your PC or not, nor if something screws up.

  1. Start the Task Manager and kill all processes that has the name of ATI*
  2. Go to Control Panel – Device Manager and expand the Display adapters node. Right click the RADEON* item and select Uninstall. Be sure to select the “Delete the driver software for this device”.
  3. Uninstall all ATI drivers and Control Center entries in the Control Panel –> Program and features.
  4. Install the Microsoft Installer Cleanup Utility. After the software is installed, start it from C:\Program Files (x86)\Windows Installer Clean Up\msicuu.exe.Find and select all entries that has the name of “ATI” and “Catalyst Control Center” and select Remove.
  5. Install the CCleaner utility. Start it and clear any entries that has the name of “ATI” or “Catalyst Control Center”.
  6. Open a Command Prompt as an Administrator. Change directory to C:\Windows and delete all ATI*.dll>Del ati*.cll /s
  7. Start Regedit, find all things named “ATI” and delete those entries.
  8. Reboot.
  9. Execute your downloaded ATI drivers/Control Center package. When the first dialog appears, click Cancel.
  10. Open a Command Prompt as an Administrator. Go to the location of where the files where extracted and find ATISETUP.EXE. (in my case C:\ATI\SUPPORT\8-12_vista64_dd_ccc_wdm_enu_72276\Driver\Bin64)
  11. Start the ATISETUP.EXE software with the following arguments: >ATISetup.EXE –install –output SCREEN
  12. Wait for it to finish and then reboot.

Now your system should of the latest Catalyst drivers and utilities installed. Good luck.