Link to home
Start Free TrialLog in
Avatar of DanielAttard
DanielAttardFlag for Canada

asked on

Can MS SQL Server 2005 Enterprise Edition Reporting Services be installed onto a MS Windows 2003 Web Edition SP1 machine?

Microsoft SQL Server 2005 does not meet the operating system requirements of Windows 2003 Web Edition SP1.  It seems only Microsoft SQL Server 2005 Express Edition meets the OS requirements however, this version of SQL Server does not allow for a database and a web server to be on housed on different machines.

The question is:  Is it possible to install Microsoft SQL Server 2005 Enterprise Edition Reporting Services (web component only) onto a Microsoft Windows 2003 Web Edition SP1 machine?
Avatar of malken00
malken00

It is still part of the SQL Enterprise Edition package, and can not be installed on 2003 Web Edition. :(
Have you considered the SQL Express with Advanced Services SP2?

http://download.microsoft.com/download/2/b/5/2b5e5d37-9b17-423d-bc8f-b11ecd4195b4/RequirementsSQLEXP2005Advanced.htm

That will work on Windows Server 2003 Web Edition SP1.

http://msdn2.microsoft.com/en-us/express/bb410792.aspx

http://msdn2.microsoft.com/en-us/express/aa718379.aspx

It includes a Reporting Services, if that is all you want.
Avatar of DanielAttard

ASKER

Probably a good idea.  I will check this out.  Thank you.
Cool. I hope it meets the requirements.
Avatar of Guy Hengel [angelIII / a3]
> however, this version of SQL Server does not allow for a database and a web server to be on housed on different machines.
where do you get that information from? you can, of course, connect to a sql server 2005 express edition on a remote computer ! ...
Thank you for these responses.  I have gone ahead and installed SQL Express with Advanced Services SP2 and now I receive the following error message when I try to generate a report:

An error has occurred during report processing.
            Cannot create a connection to data source DataSource1.
                        The feature:  The edition of Reporting Services that you are using requires that you use local SQL Server relational databases for report data sources and the report server database.  Is not supported in this edition of Reporting Services

Can someone tell me what this error means?
Are you trying to create a report from a remote database?
Yes.  I want my file server to be on a separate box from the webserver, which is running MS Windows 2003 Web Edition SP1.
ASKER CERTIFIED SOLUTION
Avatar of ptjcb
ptjcb
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial