Thursday, March 29, 2012

Determine what SQL DB Report Server uses

Is there a way to determine what SQL server/database an installation of
report server is using?
The information is encrypted within the config file and the rsconfig
utility looks like it can only be used to set new values.
Thanks.
-- Brianby default (unless you changed the name during installation), it should be
ReportServer & ReportServerTempDB.
if you did change the default name, look for xxx & xxxTempDB in SQL Server.
rob
"Brian" wrote:
> Is there a way to determine what SQL server/database an installation of
> report server is using?
> The information is encrypted within the config file and the rsconfig
> utility looks like it can only be used to set new values.
> Thanks.
> -- Brian
>|||Thanks Rob.
I was hoping that the installation of report server would be able to
show me which SQL server it was using (SQL was not installed locally),
but it doesn't look as though there is a way to view any of that
configuration information.
I ended up monitoring a few SQL instances looking for connections from
the report server to determine which SQL box it was using. Too bad that
info isn't more accessible through some of the tools.

No comments:

Post a Comment