Saturday, February 25, 2012

Report Server Configuration

I'm attempting to install and configure Report Server for the first time.

In the "Configure Report Server" dialog box the first 5 tasks are successfully configured with green circles and check marks. ( Server Status, Report Server Virtual Directory, Report Manager Virtual Directory, Windows Service Identity, Web Service Identity)

Database Setup has a red circle with an X.

The following is returned in Task Status:

Verifying Database Edition. The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.

The following error is returned in the Report Server error log:

ReportingServicesService!library!e!4/5/2007-16:52:27:: i INFO: Catalog SQL Server Edition = Workgroup

ReportingServicesService!library!e!4/5/2007-16:52:27:: e ERROR: restricted SKUs: Workgroup Express Developer Evaluation - actual SKU Workgroup

ReportingServicesService!library!e!4/5/2007-16:52:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.

ReportingServicesService!library!e!4/5/2007-16:52:27:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services.

at Microsoft.ReportingServices.Diagnostics.Sku.EnsureCorrectEdition(SqlConnection sqlConn, String connectionString, Boolean checkRestrictedSkus)

We are running SQL Server 2005 Workgroup Edition

9.00.3054.00 SP2 Workgroup Edition

It sounds like the error is saying that Report Server is not compatible with SQL Server 2005 Workgroup Edition?

Any suggestions?

Thank you.

Are you trying to install the Express version on Workgroup? I don't think that's supported. Workgroup does include Reporting Services, but you should install it from the Workgroup installation.|||I'm getting the same error message, have you found a resolution.|||My problem was operator error. I had used the wrong disc when installing SQL Server 2005 on a Small Business Server. I used the SQL Server Standard Edition disc rather than the SQL Server 2005 disc that came with Small Business Server. I uninstalled SQL Server and installed it from the Small Business Server SQL Server disc and everything was fine.

No comments:

Post a Comment