This article explains the step by step troubleshooting methodology for correcting the error “The report server is not responding. Verify that the report server is running and can be accessed from this computer” that occurs in SQL Server Reporting Services (SSRS 2005).
SQL Server 2005 Reporting Services (SSRS 2005) allows creation of reports which can be deployed to Report Server. Configuration is required for Report Server.This article provides a stepwise procedure to configure SSRS 2005 using SQL Server Configuration Manager.
Problem
When we tried to access the Report Server using the link: http://<< ServerName>>/Reports, the following error message was displayed:
”The report server is not responding. Verify that the report server is running and can be accessed from this computer”.
Solution
Step 1: On the taskbar, click Start, click All Programs and then click Microsoft SQL Server 2005. Select Configuration Tools and click SQL Server Configuration Manager. Click SQL Server 2005 Services and verify if the SQL Server Reporting Services state is Running.
Step 2: If it is not running, right-click SQL Server Reporting Services and then click Start. If you get a log on failure response, change the password or change the account to run from Network Services account as the the password of the account on which SQL Server Reporting Services is running might have expired. Configure the Reporting Services to change the password.
Step 3: In SQL Server Configuration Manager, right-click SQL Server Reporting Services and click Properties.
Step 4: On Log On tab, click Configure. You will be directed to Reporting Services Configuration Manager and ask for the Machine name and Instance name. Type the Machine name as your SQL Server on which the Reporting Server was configured previously.
Step 5: Click Connect. You will see a red cross mark (a circle with red background and a cross within the circle) on Server Status, Windows Service Identity and Initialization.
Step 6: Click Windows Service Identity, then click Built – in account and select Network Service or change the password of the Windows account on which the Reporting Service is running. You will be prompted for Encryption key Password and select the Encryption File. Type the file name with extension “.snk”.
Step 7: Click Apply.
Step 8: In the Reporting Services Configuration Manager click Database Setup. Select the Credential Type as Service Credentials from the drop-down and select Apply.
Step 9: In the Reporting Services Configuration Manager click Initialization and then. Click Initialize.
Step 10: In SQL Server Configuration Manager, right click the Reporting Services and then click Start
Step 11: Try to open Report Server using the URL http://<< ServerName >>/Reports.
Conclusion
With this step by step tutorial, People can configure SQL Server Reporting Services very easily using SQL Server Configuration Manager, Also we can easily Troubleshoot the error ”The report server is not responding. Verify that the report server is running and can be accessed from this computer”.
Related Posts
- Weblogic Server Error : Server not coming UP
- Troubleshooting SQL Server 2005 Jobs Failure
- Error while installing the SQL Server 2000 Virtual Instance
- Ad hoc Reporting using SQL Server Reporting Services 2005
- Step by Step : SQL Server 2005 Analysis Services (SSAS) Project
Tags: SQL Server 2005, SQL Server Configuration Manager, SQL Server Reporting Services, SSRS, Troubleshoot SSRS 2005
