Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1131
  • Last Modified:

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?
0
DanielAttard
Asked:
DanielAttard
1 Solution
 
malken00Commented:
It is still part of the SQL Enterprise Edition package, and can not be installed on 2003 Web Edition. :(
0
 
ptjcbCommented:
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.
0
 
DanielAttardAuthor Commented:
Probably a good idea.  I will check this out.  Thank you.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ptjcbCommented:
Cool. I hope it meets the requirements.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
> 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 ! ...
0
 
DanielAttardAuthor 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?
0
 
ptjcbCommented:
Are you trying to create a report from a remote database?
0
 
DanielAttardAuthor 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.
0
 
ptjcbCommented:
That's not supported in SQL Express Advanced Services. The database must be local.

FROM http://msdn2.microsoft.com/en-us/library/ms365166.aspx

Unsupported Features

Other editions of SQL Server 2005 include a larger set of Reporting Services features. The following list describes the features that are documented in SQL Server Books Online, but cannot be used in this edition:

    * Scheduled report processing, caching, snapshots, subscriptions, and delivery are not supported.
    * Analysis Services, Oracle, XML, SAP, SQL Server Integration Services (SSIS), OLE DB, and ODBC data sources are not supported.
    * Remote data sources are not supported. Reports that are hosted in a SQL Server Express report server must retrieve SQL Server relational data from a local SQL Server Express Database Engine instance.
    * Ad hoc reporting through semantic models and Report Builder is not supported.
    * TIFF (Image), XML, and CSV rendering extensions are not supported.
    * The Reporting Services API extensible platform for delivery, data processing, rendering, and security is not supported.
    * Custom authentication extensions and custom role assignments are not supported. You must map existing Windows domain user and group accounts to predefined role definitions.
    * Custom report items are not supported.
    * Managing a long-running report process is not supported. Specifically, you cannot use the Manage Jobs feature in Report Manager to stop report processing.
    * Scale-out deployment is not supported.

0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now