hi! I tried to connect the Reporting services of a remote db from the local machine, but got the error below, TITLE: Connect to Server ------------------------------ Cannot connect to Server. ------------------------------ ADDITIONAL INFORMATION: A connection to the computer cannot be established. (Microsoft.SqlServer.Management.UI.RSClient) ------------------------------ Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) (mscorlib) ------------------------------ BUTTONS: OK ------------------------------ Isn't we connect the remote Reporting services? --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

ACCESS DENIED, permissions?What login do you connect to?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Radhai, here is a similar thread, please refer to Sorna Kumar Muthuraj’s reply as a reference, http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/0ce14feb-17ab-4bc9-94fe-a385d57fc168 If you have any question, please feel free to ask. Thank you, Eileen

ACCESS DENIED, permissions?What login do you connect to? Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/ its windows login. I just changed the server name of SQL, automatically its shows up only windows login.. and there comes the error. Kindly tell me how to access the remote report server. Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Hi Radhai, here is a similar thread, please refer to Sorna Kumar Muthuraj’s reply as a reference, http://social.technet.microsoft.com/Forums/en-US/sqlreportingservices/thread/0ce14feb-17ab-4bc9-94fe-a385d57fc168 If you have any question, please feel free to ask. Thank you, Eileen Dear Eileen, tht link, i dint get the answer. Could u plz help me to get the accessing details of the remote Report SErver? Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

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.

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. Dear Eileen, Thanks for your reply. Actually i meant here the SQL Reporting Services from SSMS. I am given 'public' rights to the remote server's Reporting Services. I am able to logon the remote SQL server with my windows login, but denied to Reporting services. What are the other rights to be given to my login so that i could able to login to the remote reporting services. Many Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

It looks that you were trying to connect to your reporting services from SSMS. Please first refer to this article, http://msdn.microsoft.com/en-us/library/ms365170(SQL.90).aspx and make sure that the prerequisites are met.Please remember to mark the replies as answers if they help and unmark them if they provide no help

ll try n let u know. Thanks!--------------------------- Radhai Krish | Golden Age is no more far | --------------------------