We are running Reporting Services 2008 R2 on a Windows Server 2008 Standard 64-Bit server. I have a user that has full access to Reporting Services at all folder levels but IS NOT a local administrator on the 2008 server. This user can create data source connections but when he tries to test the connection by clicking on the 'Test Connection' button, he gets the following error "The permissions granted to user <username> are insufficient for performing this operation. A user that has administrator priveleges on the server can test the connection fine. Any ideas? I don't want to make this user an administrator on the server. I have exhausted all google articles but nothing seems to have helped. This is an extract from the log file: ibrary!ReportServer_0-24!3478!08/16/2011-13:45:37:: Call to TestConnectForDataSourceDefinitionAction(). library!ReportServer_0-24!3478!08/16/2011-13:45:37:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: , Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user <username> are insufficient for performing this operation.; ui!ReportManager_0-23!32a0!08/16/2011-13:45:37:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: The permissions granted to user 'HAD\skenne08' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user <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) -- Any suggestions are greatly appreciated. Thanks

The permissions granted to user 'HAD\skenne08' are insufficient for performing this operation. ---> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'HAD\skenne08' are insufficient for performing this operation. The above login is sysadmin? If you try to connect with that login via SSMS does it work?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Loise Calo, Based on the discussion above, I see that there might be a misunderstanding about permissions on desired database. Generally, the username you used to log into SQL Server must map to the desired database, and grant access permission to the desired database manually. 1. Start Microsoft SQL Server Management Studio (SSMS) with that “username” and password. 2. Expand the Security folder, then expand Logins folder. 3. Right click the login name “username”, click Properties. 4. In the Login Properties dialog, navigate to User Mapping category. Now, in the right pane of User Mapping category, click the checkbox before the desired database in Users mapped to this login: option and db_datareader or db_owner in Database role membership for: <desired database name> option. Thanks, Lola Please remember to mark the replies as answers if they help.

Hi Thanks for your quick response..... The user is not a sysadmin but can connect to the sql server and database via SSMS. The problem occurs when the user clicks on the Test Connection button when testing the data source connection. The data source connection uses the "Credentials stored securely in the report server" option and he uses his credentials. When I click on the Test Connection for the data source it works fine....I am a local administrator on the Windows 2008 Server and a sysadmin. When he clicks on Test Connection it gives him the Permission error....he is NOT a local Administrator on the Windows Server. If I make him a local Administrator on the Windows 2008 server he can successfully click on the 'Test Connection' buttion and it will successfully test the data source connection. Thanks

He has access to desired database? You can turn on Profile Login Audit event to see what is going on while he clicks on the buttonBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Yes he has access to the database. When he clicks on TEST CONNECTION is doesn't even get to the SQL server....it's like the problem is at the Reporting Services end. If I click on TEST CONNECTION, I can see his username and password successfully log into the SQL server ( as it is his credentials that used in the data source connection on Reporting Services). I am a local administrator on the Windows Server running Reporting Services. He is not. That is the only difference. Thanks