SSRS troubleshoot Report Manager URL

14,393

Solution 1

A bit late to the party, but I found this question because I ran into the same issue for some reason. Adding it to trusted sites didn't do the trick for me.

This was an SSRS instance that has been running with a client for years, but for some reason stopped working at some point.

The solution for me was to open the Reporting Services Configuration Manager, then to the Report Manager URL tab, selected the Virtual Directory field and then clicked APPLY without editing anything. It loaded for a while and then confirmed that the virtual directory was (re)created and the URL was reserved.

Report Manager URL > APPLY

Solution 2

BINGO !!!!! Problem solved !!!!! Need to do this thing to add those to trusted sites.

http://machinename and http://localhost need to be added as Trusted Sites in Internet Explorer. Tools/Option/Security/Trusted SItes.>

Thanks to all for help. M

Share:
14,393
Mario Trento
Author by

Mario Trento

Updated on June 05, 2022

Comments

  • Mario Trento
    Mario Trento almost 2 years

    all I have SQL 2012 BI, tried to make local service and no matter what can't make that active. My Computer name = T410, Default Instance of db = MSSQLServer

    I went thru SSRS Config Manager, set all like below:

    Service Account: Use build-in Account. = Networks Services

    Web Service URL: http://T410:80/ReportServer

    Database: added new db ReportServer, use SQL Server Added account with DBA rights (before I tried W auth and it also didn't work)

    Report Manager URL: http://T410:80/Reports Got all green OK statuses for each of case....

    Went thru this video setting IE tool/security settings/ adding local URL https://www.youtube.com/watch?v=nItx9xaJJi4

    And still can't make that bloody http://T410/Reports active, getting 404 error.

    In SQL Server config manager have my sql server and SSRS running, and SQL server browser too...

    Is there any way to troubleshoot this situation, what is can be wrong. I totally got crazy, looks like tried it all. I think it's till something around my accounts security. Can I see that URL somewhere running in Task Manager ?

    Please help!!! SAVE OUR SSRS !!!