Friday, July 11, 2008

SQL Server Reporting Services SharePoint Set Server Defaults

Trying to configure Reporting Services 2005 with an existing SharePoint site is painful to say the least. One of the pains was the error below when clicking on "Set Server Defaults" under Application Management within Central Admin. After searching through some forums, I found a solution

I when to the Operations tab in Central Admin and clicked "Alternate access mappings" and then selected the Central Admin collection and removed all mappings except for the default one. Then went back to "Set Server Defaults" and the error went away. I could then go back and add my mappings back in and the error still did not show.

I can't explain and really don't want to know the internal workings of Reporting Services with SharePoint but the above solution worked for me, hope it works for you too.

w3wp!library!5!07/11/2008-13:03:58:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ; Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.ArgumentException: Value does not fall within the expected range. at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemMetaDataAndContent(String path, UserContext userContext, Boolean returnContent, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper, Byte[]& content, String& mimeType) at Microsoft.ReportingServices.SharePoint.Server.Utility.GetSPItemType(String objectName, UserContext userContext, Guid& id, ISecurableObject& secObj, SharePointImpersonatedWeb& wrapper) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.InternalCheckAccess(UserContext userContext, String itemPath, SPBasePermissions requiredRights) at Microsoft.ReportingServices.SharePoint.Server.SharePointAuthorizationExtension.CheckAccess(UserContext userContext, String path, CatalogOperation requiredOperation) at Microsoft.ReportingServices.SharePoint.Server.SharePointSecurity.CheckAccess(Byte[] secDesc, CatalogOperation catalogOperation, String catalogPath) at Microsoft.ReportingServices.Library.GetSystemPropertiesAction.PerformActionNow() at Microsoft.ReportingServices.Library.RSSoapAction`1.Execute()

4 comments:

Anonymous said...

Thank you for the post. I can't tell you how much time I've spent troubleshooting this one and the fix worked just as you stated.

Anonymous said...

Thanks a Lot...!! This worked for me as well.

private key encryption said...

I used the work around to resolve the error i.e. clicked "Alternate access mappings" and then selected the Central Admin collection and removed all mappings except for the default one. Then went back to "Set Server Defaults" and the error really venished away to a great relief.Thanks

Anonymous said...

Please let me know if you're looking for a author for your weblog. You have some really good posts and I feel I would be a good asset. If you ever want to take some of the load off, I'd absolutely love to write
some content for your blog in exchange for a link back to mine.

Please send me an e-mail if interested. Kudos!

Here is my webpage; http://www.andrewsmartin.co.uk/index.php/member/19195/
My page: avrion.co.uk