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
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.
15 People are following this question.
