We help IT Professionals succeed at work.

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

1,146 Views
Last Modified: 2008-07-25
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?
Comment
Watch Question

Commented:
It is still part of the SQL Enterprise Edition package, and can not be installed on 2003 Web Edition. :(

Commented:
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.

Author

Commented:
Probably a good idea.  I will check this out.  Thank you.

Commented:
Cool. I hope it meets the requirements.
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
> 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 ! ...

Author

Commented:
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?

Commented:
Are you trying to create a report from a remote database?

Author

Commented:
Yes.  I want my file server to be on a separate box from the webserver, which is running MS Windows 2003 Web Edition SP1.
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.