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...

More Related Resource Links

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

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

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

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?

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?

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?

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?

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?

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".

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.

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.

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)

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).