• jdpaschedag (10/30/2012)


    I believe if SSRS has been installed/enabled on my server, I can find out be looking in the sys.databses table for one of the two ReportServer% DBs, right?

    How can I tell if SSRS is installed on a different server that is accessing data from my server?

    TIA!

    There are couple of ways where you can find if SSRS is installed locally or not .. Below will help you ...

    goto run->inetmgr

    then go to websites --> default websites --> look for ReportServer and ReportManager directories installed or not

    ----- or ----

    right-click My Computer >> select Manage >> select Services and Applications >> Services Internet Information

    Services >> Web Sites >> Default Web Site >> and check for the Reports and ReportServer virtual directories.

    check for deployed reports by logging on to the server : http://localhost/reports

    ______________________________________________________________________________________________________________________________________________________________________________________
    HTH !
    Kin
    MCTS : 2005, 2008
    Active SQL Server Community Contributor 🙂