Unable to find my report server name in sql -L

Question

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

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

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

-- Gianluca Sartori

Newbi SSCertifiable Points: 6546 More actions · Answer 2

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

spaghettidba SSC Guru Points: 105732 More actions · Answer 3

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

-- Gianluca Sartori

Sue_H SSC Guru Points: 90860 More actions · Answer 4

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