DanielAttard
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?
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?
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.
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.
ASKER
Probably a good idea. I will check this out. Thank you.
Cool. I hope it meets the requirements.
> 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 ! ...
where do you get that information from? you can, of course, connect to a sql server 2005 express edition on a remote computer ! ...
ASKER
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?
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?
ASKER
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.