Can't access SRS after moving SQL to new server

  • My partner moved the SQL server to a new box and keep the same name. He followed the KB article that guided him throught the process of moving SRS for SQL2005 to a new server. Yet we can't view the http://localhost/reports site. I verifed the VirtualDirectory setting and the application pool settings are identical with the old server.

    What could go wrong? where do I look for errors?

    Thanks.

  • What is the error you get?

    Some things to check and do:

    1. Is IIS installed on the new SQL box?

    2. Have you run Reporting Services Configuration on the new SQL box?

    3. In Internet Services Manager, confirm that the Reports and ReportServer virtual directories exist. Verify that they are using the correct verison of .Net by right-clicking on the virtual directory and choosing Properties and then click on the ASP.NET tab.

    Scott

  • scottwaltonmcse (10/29/2008)


    What is the error you get?

    Some things to check and do:

    1. Is IIS installed on the new SQL box?

    2. Have you run Reporting Services Configuration on the new SQL box?

    3. In Internet Services Manager, confirm that the Reports and ReportServer virtual directories exist. Verify that they are using the correct verison of .Net by right-clicking on the virtual directory and choosing Properties and then click on the ASP.NET tab.

    Scott

    Thanks Scott. It was the ASP web extension under IIS that was not changed to Allowed. Thus it can't render the page.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply