Hello, All I face issue on Sql server 2008 for deployee report first time on report server and report manager,,,,, Error rsReportServerDatabaseLogonFailed : The report server cannot open a connection to the report server database. The log on failed. Deploy complete -- 1 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Anyone please help me as soon as possible............

Hi Rajest2010, The error "The report server cannot open a connection to the report server database. The log on failed" means that: The database engine that the report server catalog database host is unaccessable. The Reporting Services service account has insufficient permissions to the access the report server catalog database. So, to fix the issue, please follow these steps: Make sure we are able to connect to the database engine from the report server machine. a) Ping the database engine server. b) Try to connect to the database engine using SQL Server Mananger Studio(SSMS)(If we have.). Or, create a .UDL file, try to connect the server from this UDL. Use the Reporting Services Configuration Manager(RSCM) to check the service account. If the report server is on the different server with the database engine, please use a domain account instead of the local account(Built-in account). Make sure the service account has permissions in the database engine. Final, please check if the report server is configured correctly. We can easily check that by checking if we can open the Report Manager(http://<server>/reports). Besides, I would suggest you to go through each steps in the RSCM to make sure the configuration is all fine. For more information, please see: Configuring a Report Server Installation (Reporting Services in Native Mode): http://msdn.microsoft.com/en-us/library/ms159624.aspx If you have any more questions, please feel free to ask. Thanks, Jin ChenJin Chen - MSFT

Hi, jin Chen I have checked as per you step all are fine means still issue is there,,,,,,,,,, This issue is happen when i deploy report on report server or report manager. deploy was not done and give me error like : ------ Build started: Project: TestingDeployee, Configuration: Debug ------ Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: TestingDeployee, Configuration: Debug ------ Deploying to http://localhost/reportserver Error rsReportServerDatabaseLogonFailed : The report server cannot open a connection to the report server database. The log on failed. Deploy complete -- 1 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Reporting Services Error The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed) Get Online Help Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Report URL is URL - http://localhost/reportserver and its windows auth. please replay me........ Thanks Rajesh

Hi, jin Chen I have checked as per you step all are fine means still issue is there,,,,,,,,,, This issue is happen when i deploy report on report server or report manager. deploy was not done and give me error like : ------ Build started: Project: TestingDeployee, Configuration: Debug ------ Build complete -- 0 errors, 0 warnings ------ Deploy started: Project: TestingDeployee, Configuration: Debug ------ Deploying to http://localhost/reportserver Error rsReportServerDatabaseLogonFailed : The report server cannot open a connection to the report server database. The log on failed. Deploy complete -- 1 errors, 0 warnings ========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ========== ========== Deploy: 0 succeeded, 1 failed, 0 skipped ========== Reporting Services Error The report server cannot open a connection to the report server database. The log on failed. (rsReportServerDatabaseLogonFailed) Get Online Help Logon failure: unknown user name or bad password. (Exception from HRESULT: 0x8007052E) Report URL is URL - http://localhost/reportserver and its windows auth. please replay me........ Thanks Rajesh