.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
Sharad
Manish
Post New Web Links

SharePoint Integration Mode error Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedExce

Posted By:      Posted Date: November 01, 2010    Points: 0   Category :Sql Server
 

Hello,

we have reports running using SharePoint integration mode...everything was woring fine since yesterday, all of sudden started getting error while opening the reports - "The permissions granted to user are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user are insufficient for performing this operation."while opening the reports from SharePoint site.

Please let me know if you have faced this before...we are having problem in production environment...

 


Thanks, Gaurav


View Complete Post


More Related Resource Links

ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An e

  
Need some help in figuring out this issue. The report I am trying to run returns over 14 million records when I get a count directly from the SQL server but I get an error after the report runs for a while. Below is the error message. Does SSRS have a limitation on the number of records? When I look at the memory utilization, it was at 79% utilization. Below is the server setup. Am not sure what else I can do to resolve this. Microsoft SQL Server 2008 (SP1) Processor : Intel Xeon CPU X5355 @ 2.66 GHz (2 procs)...64 bit Memory : 32 GB library!WindowsService_0!152c!09/09/2010-13:47:42:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database., ; dbcleanup!WindowsService_0!152c!09/09/2010-13:47:42:: e ERROR: Sql Error in CleanOrphanedSnapshots: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.    at System.Data.SqlClient.SqlConnection.O

Microsoft.SharePoint.Client.File.OpenBinaryDirect - returns a 404 error if the file being requested

  
Hopefully someone can help with this. I'm using Sharepoint 2010. On the server I have manually created a folder in the "Shared Documents" folder called "bin" and uploaded a file into this folder If I attempt to access the files in this folder using the Microsoft.SharePoint.Client.File.OpenBinaryDirect function,  I receive the following error: A first chance exception of type 'System.Net.WebException' occurred in System.dll: System.Net.WebException: The remote server returned an error: (404) Not Found.    at System.Net.HttpWebRequest.GetResponse()    at Microsoft.SharePoint.Client.SPWebRequestExecutor.Execute()    at Microsoft.SharePoint.Client.File.OpenBinaryDirect(ClientContext context, String serverRelativeUrl). Any other files in any other folders under the shared documents folder are accessible. Here is my example code: ClientContext clientCTX = new ClientContext(SPURL);             //Pass the credentials to the client context             clientCTX.Credentials = credentials;             List DeployFilesList = clientCTX.Web.Lists.GetByTitle("Shared Documents");             CamlQuery caml

Building Reports in SharePoint Integration Mode

  
 I configured and connected SSRS to my SharePoint farm, but how do I go about creating reports?  The usual <my server>/reports url is disabled in SharePoint integrated mode.  Can someone point me in the right direction? Thanks, Eric

Report Builder 3 report preview error in SharePoint integrated mode

  
Hello folks! I've faced some strange error with RB 3.  My environment is: Win 2008R2+SQL2008R2 CU3+Sharepoint Foundation services 2010 SharePoint services integrated with Reporting Services.  When I try to run RB3 from SharePoint library and built some report I get strange error at the previw screen : Failed to preview report. The item 'http://myserver/cd6409dc-1089-4e8a..' cannot be found. Details: System.Web.Services.Protocols.SoapException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ItemNotFoundException: The item 'http://myserver/cd6409dc-1089-4e8a-a2a4-f231c97039aa' cannot be found.    at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)    at Microsoft.ReportingServices.WebServer.ReportingService2010.CreateReportEditSession(String Report, String Parent, Byte[] Definition, String& EditSessionID, Warning[]& Warnings)  The most intresting thing, that my test environment with Win 2008R2 CTP+SQL2008R@ Nov CTP is working properly without any error. Could you please advise how to resole this problem? Thanks in advance, Andre.  

Trying to repair SharePoint 2010, running into an error with Microsoft.Office.InfoPath in GAC...

  
We've got an environment which has been hit badly by something we're not yet sure of. SharePoint has ceased working completely, and when I try to run SharePoint Configuration Wizard, it stops with an error concerning an windows assembly. Could not load file or assembly 'Microsoft.Office.InfoPath.Server', VErsion=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. Signature specified is zero-sized. (Exception from HRESULT:0x80131237) How can I fix that assembly?

SharePoint 2010 Reporting Services Integrated-mode Error

  
I am running SharePoint 2010 and Reporting Services 2008 R2 SharePoint integrated-mode. I am able to browse to the reportserver site : http://DBserver/reportserver which lists my site collections and I am able to get to the document library which holds my reports. However, when I try opening a report I get the following error: Report Server has encountered a SharePoint error. (rsSharePointError) The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. For more information about this error navigate to the report server on the local server machine, or enable remote errors I am able to resolve that issue by going to Central Admin, Application Management, General Settings and turning Web Page Security Validation Off. But if I do that I get an error when using silverlight features like site, or list creation. Any ideas?

Parameter value filter based on user in SSRS (SharePoint Integration mode)

  

Hello..we have a reuirement where we have to filter the parameter value in the drop down based on the user who is accessing the report. We have form and Windows authenication enabled in the SharePoint site (some users will be from inside the network using windows and some will be accessing the site using internet using the Form Authentication).

Please let me know what would be the best way to handle this reuirement? Do we need to create a separate table  and store the User Information along with the parameter values they have access to, pass the userid from Report to db and then fileter the records using this table? OR Can we create a SharePoint List to maintain the user access information and then directly fetch the user information from the list using T-SQL to filter the records?

Please let me know your suggestion...

 


Installing Microsoft Office SharePoint Server 2007 on Windows 7, getting error please help

  
Hi all Installing Microsoft Office SharePoint Server 2007 on Windows 7 Ultimate 32-bit, getting error "Windows Server 2003 sp1" is required for this product, any help please.

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office comp

  
I am encountering this error during setup. The server previously had WSS 3.0 and the Group Board Workspace. I uninstalled those and installed sharepoint foundation 2010. Initially It was up and running but I was receiving errors trying to load the group space template, so I uninstalled SPF2010. cleaned up the registry pointers to the old WSS3.0 and Groupboard Workspace and tried to reinstall. Now I get the error

Microsoft SharePoint server 2010 encountered an error during setup. One or more required office components failed to complete successfully.

Looking into the issue it appears that setup cannot install the embedded sql server, since the logs indicate a dbwrap error. There are no "pendingfilerename" operations which fixed this problem for some. I tried to install as a farm but it won't allow me to use a local admin account.  I also looked at the sql configurations and the windows internal database is running.

Any ideas how to I can remove the windows internal database and reinstall SF2010?


SP2010 Configuration Error: MicroSoft.SharePoint.SPException Language Not Supported

  

I am facing "MicroSoft.SharePoint.SPException: Language not supported" error while configuring through SP Products configuration wizard. The solution suggested to this issue in different forums is to add 1033 entry in the registry. For me it already exists. Even then, it generated the error. Any suggestions?

 

-K


Microsoft Project 2010 synchronize with SharePoint Foundation error (invalid characters)

  

I have been unable to synchronize my MS Project with a SharePoint Foundation tasks list. Each time I try I get the following message:

"Unable to synchronize the project with the SharePoint tasks list because the list name contains invalid characters. Modify the list name and synchronize again. Valid list names cannot contain any of the following characters: !.[]'"

I click OK and the process stops. It creates the Task list in SharePoint but does no more.

The SharePoint task list name is not the issue. I've tried a few (Project Tasks, tasks etc). It's not the Task Name in Project either. I'm using a test project file with only two tasks called "Startup" and "planning".

Any ideas?


Sharepoint 2010 Live Id Integration, Configuring Microsoft Service Manager.

  

Hi guys i have been following the post:

http://www.wictorwilen.se/Post/Visual-guide-to-Windows-Live-ID-authentication-with-SharePoint-2010-part-1.aspx

To implement Sharepoint 2010 Live Id Integration.

I am lost at configuring the microsoft service manager, for this values:

 

Domain Name:

DNS Name:

Default Return Url.

I don't understand what i have to put under those values.

My domain name is Sharepoint.

 

I would like somebody to explain me with a practical exemple what is the right way to configure those values succesfully, if you need more information about my specific scenario please let me know.

Many thanks

Loogares

 


Error loading and running event receiver Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventRecei

  

Hi all, i found the below error in event log. How can i fix this issue.

Event ID: 6875            Source: Windows SharePoint Services 3

Error loading and running event receiver Microsoft.SharePoint.Workflow.SPWorkflowAutostartEventReceiver in Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Additional information is below.

: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Please help me out in this issue. Thanks in advance.

Srikanth

K2Blackpearl, Sharepoint, .Net


500 Error generating SSRS Report in SharePoint Integrated Mode

  

Our environment looks as follows:

- MOSS 2007 Site/Central Admin (Enterprise) on Server A

- SQL Reporting Services 2008 R2 on Server B

- Report created on workstation using Report Builder 3.0

- SharePoint Library (with Promoted InfoPath fields) is the XML datasource

 

The report generates perfectly fine in development, but once loading the RDL up to the SP Site we get the following error when trying to view:

 

An error occurred during client rendering.

The remote server returned an error: (500) Internal Server Error.

 

Using this generic information we have checked into numerous apparent fixes, from confirming settings in the Central Admin, to changing the Zone Authentication to NTLM, to ensuring Anonymous Access is disabled, as well as some tweaks in IIS, etc.

We're still not having any luck getting the report to generate.

Any assistance would be greatly appreciated.


My Site not accessible, getting error "The evaluation version of Microsoft Office SharePoint Server

  


Hi,
I am facing this problem from last couple of days and I am not able to figure out the root cause or find some solution. When I try to access My Site. It gives "The evaluation version of Microsoft Office SharePoint Server 2007 for this server has expired" error.

I tried creating different web application for my site, and created the root site collection by selecting MySite Host template. After site collection creation when tried accessing it ended up in same error. but when i tried creating site collection of different template it worked. Only for My Site I am getting that error.

I have tried all options mentioned in the below URLs. still not able to resolve.

http://www.folin.se/index.php/2007/10/15/the-evaluation-version-of-microsoft-office-sharepoint-server-2007-for-this-server-has-expired/michaelfolinse

http://blogs.msdn.com/b/joelo/archive/2008/01/02/evaluation-version-expired-but-not-really.aspx

http://blogs.pointbridge.com/Blogs/ayyapusetty_raja/Pages/Post.a

SSRS 2008 R2 running in SharePoint 2010 Integration mode - Not able to schedule reports.

  

Hi,

I am unable to schedule report am getting following error when trying to schedule an SSRS report from ReportViewer Webpart in SharePoint 2010.

  • The current action cannot be completed. The user data source credentials do not meet the requirements to run this report. Either the user data source credentials are not stored in the report server database, or the user data source is configured not to require credentials but the unattended execution account is not specified. (rsInvalidDataSourceCredentialSetting)

I have SSRS 2008 R2 running in SharePoint 2010 Integration mode on Win 2008 R2 System.

I have also setup the unattended execution account from the Reporting Services Configuration Manager, which has appropriate privilates on the database to generate report.

Also, I have reporting webservice setup @ following url (am using the named instance of SQL Server):

http://<Servername>/ReportServer_SQLSERVER97170

Am able to view the report from report viewer webpart but unable to schedule it.

Kindly let me know what's going wrong.

Thanks in Advance,

Sachin R. Chavan.


Sachin R. Chavan.

CLR Integration With Microsoft SQL Server

  
Transact-SQL provides as much flexibility as possible but, because it is not a real programming language, it has some shortcomings about many issues (memory management, exception handling, debugging, file processing (or streaming), object-orientation (classes), or thread management). Transact-SQL also lacks features of normal libraries (arrays, collections, serialization, expressions, or string manipulations, etc).
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend