Post reply

Unable to find my report server name in sql -L

  • September 8, 2016 at 2:27 am

    #313205

    I cannot find my report server name in sql -L. What are the possible issues and How can I fix?

    I am using sql 2012 on win 10.

  • September 8, 2016 at 2:45 am

    #1899713

    sqlcmd -L returns entries for SQL Server database engine instances, not for SSRS instances.

    -- Gianluca Sartori

  • September 8, 2016 at 3:09 am

    #1899719

    Thanks. Then how do I check my report server is up???

  • September 8, 2016 at 8:06 am

    #1899822

    Connect to the report server URL with your browser or with SSMS.

    -- Gianluca Sartori

  • September 8, 2016 at 11:50 am

    #1899898

    If you want a way to do it from the command line, you can use sc query. If this is still for your local installation, you can use:

    sc query "SSRS Service Name"

    The name in services is usually ReportServer so

    sc query "ReportServer"

    For a remote report server, you can use:

    sc \\<servername> query "SSRS Service Name"

    Sue

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

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