Solved: SSRS Config Manager | Experts Exchange

Create Account

SSRS

Questions

Followers

Top Experts

aneilg🇬🇧

SSRS Config Manager

When i try and start my server status i get an error.

My Log File

ReportingServicesService!library!8!24/09/2009-10:23:55:: e ERROR: restricted SKUs: Workgroup Express Developer Evaluation - actual SKU Developer
ReportingServicesService!library!8!24/09/2009-10:23:55:: 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!8!24/09/2009-10:23:55:: 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)
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectEdition()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!24/09/2009-10:23:55:: Attempting to start service again..

-------------------------------------

ReportingServicesService!library!4!24/09/2009-10:23:55:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'BGM-XP-88\ASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'BGM-XP-88\ASPNET' is not recognized.
ReportingServicesService!servicecontroller!4!24/09/2009-10:23:55:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'BGM-XP-88\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.

Marten Rune🇸🇪

I gather you are using either express or workgroup edition.

link: http://technet.microsoft.com/en-us/library/cc966542.aspx
Shows why and wich version you could/should choose.

/Marten

aneilg🇬🇧

ASKER

Thanks for your help.

Because i installed Reporting Service & IIS after SQL was originally installed it caused all sorts of problems.

I had to rename the SQL folder path, uninstall SQL Client, then delete both reports & reportserver in IIS. Then restart my service, restart IIS.
Then I un-installed SQL then re-installed it.

ASKER CERTIFIED SOLUTION

Marten Rune🇸🇪

membership

Signing up is free and takes 30 seconds. No credit card required.

Create Account

aneilg🇬🇧

ASKER

PARTIALLY answered.

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.

SSRS

Questions

Followers

Top Experts

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.