hi! I have developed a SSRS report using the local DB and deployed the report in the local Report server. the report is accessible to the users to whom which i have given the rights to the DB as well the report server. in similar, when tried to do a report using a DB which is in server and deploying the report in the LOCAL report server, the report is not accessible to the users to which the rights to the remote db and right to the LOCAL report server are given. its throwing the error,' ""An error occurred during client rendering. An error has occurred during report processing. Cannot create a connection to data source 'SALES'. Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. "" Is there any special settings to be done in order to view the report from report server URL?? Kindly help me.. --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

The Account in which SQL server reporting service should have access to the remote DB. If i am not wrong the login user will impersonate this account. please check that.

The Account in which SQL server reporting service should have access to the remote DB. If i am not wrong the login user will impersonate this account. please check that. Could you kindly explain me in detail? If im going for the option with 'Impersonate the authenticated user after a connection has been made to the data source' from REport manager --> Data source --> properties --> General : im getting the following error, An error occurred during client rendering. An error has occurred during report processing. Cannot impersonate user for data source 'SALES'. Log on failed. Value does not fall within the expected range. how to impersonate the the account? Thanks ! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Read the below link for details http://msdn.microsoft.com/en-us/library/ms156468.aspx A similar thread tooo http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/240124f5-a400-4443-be5a-6ca3e0a93d00/

Read the below link for details http://msdn.microsoft.com/en-us/library/ms156468.aspx A similar thread tooo http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/240124f5-a400-4443-be5a-6ca3e0a93d00/ hi! SORRY FOR UNMARKING AS ANSWER, as it hasn't helped me ... When i tried to follow the steps provided as the answer from the thread, http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/240124f5-a400-4443-be5a-6ca3e0a93d00/ i got the following error, An error occurred during client rendering. An error has occurred during report processing. Cannot impersonate user for data source 'SALES'. Log on failed. Value does not fall within the expected range. Please give me a solution, --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, Please kindly refer to the thread below for detailed information. http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/dadcd52a-808a-4df2-9f5d-9768deb76ea7?prof=required If any question, please feel free to ask. Thanks, Eileen.

Hi Radhai, Please kindly refer to the thread below for detailed information. http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/dadcd52a-808a-4df2-9f5d-9768deb76ea7?prof=required If any question, please feel free to ask. Thanks, Eileen. Hi Radhai, "Access Denied" error message means that the user did not have the permission to logon to the SQL server although the authentication passed. Based on the inforamtion we have, it usually is a double-hop issue and I would suggest you use Stored Credential for the DataSource connection to work it. Please note, the credential that you provided should be granted to logon to the SQL server. To configure Stored Credential, please refer to the article, How to: Store Credentials for a Data Source (Report Manager):http://msdn.microsoft.com/en-us/library/ms159736.aspx NOTE: The format of the username should be "<domain name>\<account name>" (without quotation). While configuring the Stored Credential to Report DataSource in Report Manager, please also remember to check the option "Impersonate the authenticated user after a connection has been made to the data source". The option means that the Reporting server will try to connect to the SQL Server with the Stored Credential and then the query will be executed as if it is run by that account that we specified above. If you have questions, please ask. Thanks, Eileen. This one helped me, i did gave the user login with domain assists , where i dint not filled the feild before. Thanks Eileen ! --------------------------- Radhai Krish | Golden Age is no more far | --------------------------