SSRS 2008 Is IIS-Free

Microsoft has severed the IIS dependency for SQL Server Reporting Services (SSRS) in the 2008 version, according to a couple sources.

Reasons cited include :

  • Deployment considerations (some enterprises prohibit IIS on database servers).
  • Better configuration.
  • Better resource management.

 :{> Andy

Installing Reporting Services 2005 on Vista

I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM.

I’m now trying to install a default instance of SQL Server 2005 Developer and can’t get Reporting Services to run because IIS isn’t installed. After trying the click-a-bunch-of-stuff in the “Turn Windows features on or off” dialog, I decided to read the instructions. I may have to start by reading the instructions from now on… click-a-bunch-of-stuff may no longer be my default…

The instructions are here – and I am happy to Report (pun intended) that they work.

The dialog you’re after looks like this:

Be sure to install the latest service pack (SP2 at the time of this writing) when the install completes.

:{> Andy

Installing Reporting Services 2005 on Vista

I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM.

I’m now trying to install a default instance of SQL Server 2005 Developer and can’t get Reporting Services to run because IIS isn’t installed. After trying the click-a-bunch-of-stuff in the “Turn Windows features on or off” dialog, I decided to read the instructions. I may have to start by reading the instructions from now on… click-a-bunch-of-stuff may no longer be my default…

The instructions are here – and I am happy to Report (pun intended) that they work.

The dialog you’re after looks like this:

Be sure to install the latest service pack (SP2 at the time of this writing) when the install completes.

:{> Andy

Installing Reporting Services 2005 on Vista

I have a new Dell desktop. The first thing I did was install Vista 64-bit and bumped it up to 4GB of RAM.

I’m now trying to install a default instance of SQL Server 2005 Developer and can’t get Reporting Services to run because IIS isn’t installed. After trying the click-a-bunch-of-stuff in the “Turn Windows features on or off” dialog, I decided to read the instructions. I may have to start by reading the instructions from now on… click-a-bunch-of-stuff may no longer be my default…

The instructions are here – and I am happy to Report (pun intended) that they work.

The dialog you’re after looks like this:

Be sure to install the latest service pack (SP2 at the time of this writing) when the install completes.

:{> Andy

SSIS and Visual Studio 2008

Harper Trow of GenYSystems tells me he cannot open SSIS 2005 packages in Visual Studio 2008. I have not yet confirmed this personally but I trust Harper implicitly – he’s one of the smartest developers I know. More later…

In a related story: there’s a download that allows you to interact with SQL Server 2008 CTP 5 from within Visual Studio 2005. Check out Visual Studio 2005 Support for SQL Server 2008, Community Technology Preview.

:{> Andy