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?

How to get remote server datetime

Hi All ,
I have 3 sql servers located at different time zones. Say, CST,PST,EST.
Now how can I get current time at EST,PST from the SQL server located
at CST? Is there any query to do that?
I have a stored proc located in SQL server at CST zone where I need to
query for the current date/time of the other zone sql servers.
I tried below query at CST SQL server
SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
But it always gives CST datetime.
Please reply...
Thanks
RP
Haven't tested but it should work using Openquery instead of
the 4 part name. The statement passed in the openquery is
executed on the remote server.
-Sue
On Fri, 27 Apr 2007 12:24:01 -0700, Ram
<Ram@.discussions.microsoft.com> wrote:

>Hi All ,
>I have 3 sql servers located at different time zones. Say, CST,PST,EST.
>Now how can I get current time at EST,PST from the SQL server located
>at CST? Is there any query to do that?
>I have a stored proc located in SQL server at CST zone where I need to
>query for the current date/time of the other zone sql servers.
>I tried below query at CST SQL server
>SELECT TOP 1 GETDATE() FROM [SERVER-PST].master.dbo.syslocks
>But it always gives CST datetime.
>Please reply...
>Thanks
>RP
|||Hi Sue,
It works gr8...
Thanks for the help...
"Sue Hoegemeier" wrote:

> Haven't tested but it should work using Openquery instead of
> the 4 part name. The statement passed in the openquery is
> executed on the remote server.
> -Sue
> On Fri, 27 Apr 2007 12:24:01 -0700, Ram
> <Ram@.discussions.microsoft.com> wrote:
>
>
|||Hi,
Can you please write the exact syntax you used for Openquery? I also have
requirement similar to this.
Thanks for your help.
Namwar
"Ram" wrote:
[vbcol=seagreen]
> Hi Sue,
> It works gr8...
> Thanks for the help...
>
> "Sue Hoegemeier" wrote: