Tuesday, August 4, 2009

SQL Server 2005 on Windows Server 2008

If you want to install SQL Server 2005 with Reporting Services on Windows Server 2008 you have to jump through a few hoops. Reporting Services is dependent on IIS 6 and SQL Server 2008 runs IIS 7. However, there is the capability to emulate II6, which is critical to making this work.

There is a great blog post on this issue at iGregor, where he walks you through the exact configuration options to make this work.

Hope this helps all those who see that grayed out Reporting Services box in SQL Server 2005 install and are shaking their heads.

1 comment:

  1. Thanks Arthur Hedge.

    You give a good post installing SQL server 2005.

    Recently I just came across a good article on Windows 2003 Server Emergency Shutdown
    Here is its link.