Wednesday, February 13, 2013 4:46 PM
I have one question on SharePoint and Reporting services. We installed Reporter services in SharePoint integrated mode in one of Dev environment server. We installed sharepoint 2010 on this server. After one week we found that Reporting services log files are occupied Gigs of space in below location in the server. I'm trying to figure it out the reason behind this. Appreciate any suggestions to restrict these logs
Reporting services version is 2012
Log file location is :C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\LogFiles
Sample name of Log file: reportserverservice_5f3da2ea-c967-43ae-a68b-a90388d2bced_02_11_2013_19_03_51
Thursday, February 14, 2013 4:16 PM
Check if some error is occurring on your farm with SharePoint and SSRS.
Go to Event Viewer or use SharePoint ULS Log Viewer.You can create a script to delete them periodically.
- Edited by irusulMicrosoft Community Contributor Thursday, February 14, 2013 4:16 PM
Friday, February 15, 2013 4:46 PM
Hi Irusul, thanks for your inputs.
I observed log, only below error information has been repeated through all the logs. I'm thinking to create a job to delete all the logs these logs on daily basis. All are .log filesPlease have a look at below log info
Here is the error message:
w3wp!runningjobs!1d!02/15/2013-09:24:04:: e ERROR: Error in timer Database version check : Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.
w3wp!library!75!02/15/2013-09:24:04:: i INFO: Catalog SQL Server Edition = Express
w3wp!library!75!02/15/2013-09:24:04:: e ERROR: restricted SKUs: Developer Evaluation Workgroup Express Web - actual SKU Express
w3wp!library!75!02/15/2013-09:24:04:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: , Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedException: The feature: "The Database Engine instance you selected is not valid for this edition of Reporting Services. The Database Engine does not meet edition requirements for report data sources or the report server database. " is not supported in this edition of Reporting Services.;
Appreciate further inputs on this
Monday, February 18, 2013 3:17 PM
Are you using SQL Server Express? This is what the error is saying.
If you need additional features of SSRS, consider upgrading to the BI Edition.
Monday, February 18, 2013 3:27 PM
It has SQL server Express edition which has been installed with SharePoint 2010. After that I installed SQL 2012 on the same server and I was installed SQL report services in SharePoint mode.
- Edited by Kpvuppala Monday, February 18, 2013 3:27 PM
Tuesday, February 19, 2013 3:28 PMExpress Edition has some limitation. Please be aware of them when considering SQL Server Express in your system design.
More information about Reporting Services in SQL Server Express with Advanced Services: Reporting Services in SQL Server Express with Advanced Services
Tuesday, February 19, 2013 5:58 PM
Yes please double check the Report Server Database Server Edition Requirements here (http://msdn.microsoft.com/en-US/library/cc645993.aspx) and for the SharePoint integration check the Reporting Services Features.
To summarize you can install your Reporting Services with a edition (I'm guessing you are using Standard or above) and connect to a database which has a different edition (for your case Express), but it won't work if is not a supported combination (that's the error you are seeing), so you can check the two tables I mentioned and see what features you have available based on your edition of Reporting Services and what are the Report Server Database Server Edition requirements that match your edition.
This posting is provided "AS IS" with no warranties, and confers no rights
- Marked As Answer by Mike YinMicrosoft Contingent Staff, Moderator Sunday, March 03, 2013 4:01 PM