Friday, March 23, 2012

How to get the database location of a installed reporting service?

I have reporting service installed, but I didn't install it. I
cannot figure out where the reporting service database located. We
have two SQL servers and the databases reside on BOTH servers. Also
the resportserver.mdb and reportservertempdb.mdb files reside on both
servers (obviously) and both have fairly recent dates. It's quite
possible that someone else on my network has a Report Server running.
How can I figure out *which* database is mine'
Thank you.If you are running RS 2005 then on your report server you will have an app
called Reporting Services Configuration. When you run it, it shows a variety
of configuration options including the database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<doug.masters@.gmail.com> wrote in message
news:1176912515.518742.324170@.o5g2000hsb.googlegroups.com...
>I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.|||On Apr 18, 11:52 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you are running RS 2005 then on your report server you will have an app
> called Reporting Services Configuration. When you run it, it shows a variety
> of configuration options including the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
Sorry, I forgot that little tidbit of info... Reporting Services
2000|||On Apr 18, 11:08 am, doug.mast...@.gmail.com wrote:
> I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.
OK, I've poked thru files & the registry to see if I can find ou the
path to the databses and no luck. Anyone know how to find this in
RS 2000?

No comments:

Post a Comment