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
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.