question

Mandar Alawani avatar image
Mandar Alawani asked

Find reporting server instance from Reportserver database

Hi All, I have a SQL server 2005 database instance which has the Reportserver and ReportservertempDb databases on it. I checked the Reporting services configuration tool and it could not find the SSRS on the local server. I also cannot find the Reporting services on the server (using SQL server configuration manager & services.msc) Is there a way to know from the Reportserver database (any configuration table) or any other way to know which Reporting server instance is using this database? Regards, Mandar
sql-server-2005reporting-servicesreportserverssrs 2005
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
sp_lock avatar image
sp_lock answered
I guess you could check with **SP_WHO2** or **SP_WHOISACTVE** where the connection are coming from for the reportserver and reportservertembdb. You may see a few connections from the machine executing the report, but you should also see the SSRS host. Or, if profiler is allowed in your prod environment you could include the HOSTNAME.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.