I try to create a new datasource on SSRS 2008 R2. When I try to Test Connection it gives me the error "The permissions granted to user 'DOMAIN\USERNAME' are insufficient for performing this operation. (rsAccessDenied" I am able to Test connection on already existing datasource. The user is sysadmin on SSRS and All Roles on the root folder in SSRS. Also has Dbo rights on the database. The Error log in SSRS sais: library!ReportServer_0-25!9b8!08/29/2011-10:28:31:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\USERNAME' are insufficient for performing this operation.; ui!ReportManager_0-26!d7c!08/29/2011-10:28:31:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'DOMAIN\USERNAME' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'DOMAIN\USERNAME' are insufficient for performing this operation. at Microsoft.ReportingServices.WebServer.ReportingService2010Impl.TestConnectForDataSourceDefinition(DataSourceDefinition DataSourceDefinition, String UserName, String Password, String& ConnectError) at Microsoft.ReportingServices.WebServer.ReportingService2010.TestConnectForDataSourceDefinition(DataSourceDefinition DataSourceDefinition, String UserName, String Password, String& ConnectError) at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at Microsoft.SqlServer.ReportingServices2010.ReportingService2010.TestConnectForDataSourceDefinition(DataSourceDefinition DataSourceDefinition, String UserName, String Password, String& ConnectError) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.<>c__DisplayClass11b.<TestConnectForDataSourceDefinition>b__11a() at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.SoapMethodWrapper`1.ExecuteMethod(Boolean setConnectionProtocol) at Microsoft.SqlServer.ReportingServices2010.RSConnection2010.TestConnectForDataSourceDefinition(DataSourceDefinition dataSourceDefinition, String userName, String password, String& connectError) at Microsoft.ReportingServices.UI.DataSourceProperties.TestConnection(String& message) at Microsoft.Reporting.WebForms.TestConnectionControl.ValidateButton_Clicked(Object sender, EventArgs args) at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ui!ReportManager_0-26!d7c!08/29/2011-10:28:31:: e ERROR: HTTP status code --> 200 I Tries all suggestions on forums and blogs but nothing helped.... Please help? René van Osnabrugge W: www.delta-n.nl B: osnabrugge.wordpress.com T: @renevo

Can you connect with that domain account via SSMS?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Thanks! That was actually one of the first things I tried. Ren van Osnabrugge W: www.delta-n.nl B: osnabrugge.wordpress.com T: @renevo

Hmm the error clearly says "ACCESS Denied" So, you have no problem to connect to SQL Server via SSMS, you have no problem to connect to SSRS server , am I right? Do you try test connection on RM? http://www.c-sharpcorner.com/UploadFile/nipuntomar/rsAccessDenied05122009015015AM/rsAccessDenied.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

I have no problems with other (already exisiting) dat sources. It only goes for new DS. I can access all databases and reports. I am even admin on all.Ren van Osnabrugge W: www.delta-n.nl B: osnabrugge.wordpress.com T: @renevo

Hi renevo, Please open data source props and make sure that credentials are set to "Windows integrated security" or "Use as Windows credentials when connecting to the data source". For more information about the topic, please refer to the following link, Troubleshooting Server and Database Connection Problems: http://msdn.microsoft.com/en-us/library/ms156468.aspx Thanks, Eileen Forum Support Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

I checked Credentials stored securely in the report server AND Use as Windows credentials when connecting to the data source This gives me the described error. Windows Integrated Security also gives me this error. Only on the newly created datasourceRen van Osnabrugge W: www.delta-n.nl B: osnabrugge.wordpress.com T: @renevo

Hi renevo, It seems strange that this issue was only appeared in newly created datasource, have you compared the configurations between the newly datasource and older datasource? Did both of them access to the same database and have the same configurations? I also suggest you change another computer and have a try. Thanks, Eileen