IIS and SQL Server 2005 Express Edition

hi

Currently have SQL Server 2005 Express Edition installed. Wanted to install reporting services, but wouldn't let me re no IIS as I only have Windows XP Home Edition.

My question is therefore: Is there any way of installing IIS to allow me to install Reporting Services for SQL Server 2005 Express Edition

Many thanks

Tim

Leicester, UK

Hi,

actually there is none without breakign the licensing rules.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

I have XP Pro but IIS was not installed at the beginning.

I would want to use Sql Server 2005 Express ( with reporting ).

I never found the way to install IIS. Is There anybody who could tell me how to install IIS ?

I've installed the advanced version of Sql Server 2005 Express. Is there any problem to install IIS after SQL Server ?

Excuse me for my poor English and thank you for advance

Have a nice day

|||

hi to unistall IIS, you have to access the Setitngs, Control Panel Add or Remove Programs, Add or Remove Windows Components.. applet..

regards

|||

I too had a problem running/using reporting services as I didn't have IIS installed on my PC (XP Home edition).

After rebuilding the computer and installing XP Proffessional I installed SQL Express with Avd Services and Toolkit etc but forgot to install the IIS correctly (I think I installed the .net framework before installing IIS). So even after installing IIS my reports would not work.

After all that hassle I started AGAIN with a clean install of XP Proff, installed all the components of IIS, then installed the.net 2.0 framework and then installed SQL Express etc and it worked fine.

Good luck

Garry

|||

Thank you for your clear answer

I see that if you do not install IIS before SQL Server, it's impossible to use reporting services.

All i regreat is that Microsoft nowhere warns about that problem except at the beginning of the installation of SQL Server with a meagre warning.

I hope that Microsoft will correct this absence in the documentation to avoid complete desinstallation/installation of Visual Studio,net 2.0 framework and SQL Server.

Have all a good day

|||

There is no need to start everything from scratch if you have not installed IIS prior to installing SQL Server. There is a need to configure ASP.NET on IIS once you have installed it though because it doesn't happen automatically unless you install the .NET Framework 2.0 after IIS, which you didn't do. Instructions on how to register ASP.NET on IIS can be found here. Once you've registered ASP.NET, you can install Reporting Services by going into Add/Remove Programs, Selecting SQL Server 2005 and using the option to Change an existing installation. The maintenance mode installer will allow you to add Reporting Services to your installation without removing anything else.

As to the wish that we would document this, we do. Durring installation of SQL Server you are warned that IIS is not installed and you have the option of stoping the installation of SQL Server, installing IIS and then starting again.

Mike