Post reply

How to programmatically detect that SSRS is installed?

  • December 2, 2009 at 12:50 pm

    #214429

    Is there some way to programmatically detect that SSRS is installed using SQL or T-SQL or even C#?

  • December 2, 2009 at 9:15 pm

    #1086881

    I think you can check the system services(services.msc).

    But i don't know any other easy way is available or not.

    Hope the below url will help you

    http://www.codeproject.com/KB/dotnet/netdiagnostics3.aspx

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • December 2, 2009 at 9:32 pm

    #1086883

    Arunkumar S P (12/2/2009)

    I think you can check the system services(services.msc).

    But i don't know any other easy way is available or not.

    Hope the below url will help you

    http://www.codeproject.com/KB/dotnet/netdiagnostics3.aspx

    If the user could go as far as services.msc, he may also look in SQL Server Configuration Manager.

    I guess the OP wants it deliberately from Code (either T-SQL or C#).

    Only thing I could recollect is to run the following command.

    select [NAME] from Master.sys.databases where [Name] like '%$%TempDB'

    If the command returns any rows, then it would be an indication that Reporting Server is installed. the reason I say it is an indication is, it may also be a user created database.

    But I tried looking in all of my Reporting Server TempDB's the Database_ID in the above mentioned table is 6. Hope it may be useful.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 2, 2009 at 9:36 pm

    #1086884

    Hi Medishetty,

    I aggree with you. This is an good idea too.

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

  • December 3, 2009 at 9:13 am

    #1087194

    Thanks so much I will do some testing with that!

Viewing 5 posts - 1 through 4 (of 4 total)

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