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 Enterprise Mgr on pc?

I have installed a 64-bit SQL Server 2005 standard edition onto my database
server. I now want to install the client onto my pc.
How do I install onto client pc?
Thanks!
You pop in the CD or DVD that you used to install the server components and
select the "Server components, tools, Books Online, and samples"
installation.
Click through until you can select the components to install.
When you are on that window choose Workstation Components, Books Online, and
development tools checkbox.
Keith Kratochvil
"kwl88" <kwl88@.discussions.microsoft.com> wrote in message
news:3CEC8CD5-9F7B-437E-8B4F-968C3E5A62C1@.microsoft.com...
>I have installed a 64-bit SQL Server 2005 standard edition onto my database
> server. I now want to install the client onto my pc.
> How do I install onto client pc?
> Thanks!
|||Keith:
You would be incorrect!
I recieve the following error message:
"Error: %1 is not a valid Win32 application"
It appears that I need to install a 32bit SQL Server Client. OR is there
some workaround ou there?
Thanks!
"Keith Kratochvil" wrote:

> You pop in the CD or DVD that you used to install the server components and
> select the "Server components, tools, Books Online, and samples"
> installation.
> Click through until you can select the components to install.
> When you are on that window choose Workstation Components, Books Online, and
> development tools checkbox.
> --
> Keith Kratochvil
>
> "kwl88" <kwl88@.discussions.microsoft.com> wrote in message
> news:3CEC8CD5-9F7B-437E-8B4F-968C3E5A62C1@.microsoft.com...
>
>
|||Just install the 32 bit client onto the client computer.
I would download the 32 bit Windows Server 2005 Evaluation and just install
the client tools.
Both the 32 and 64 bit management studios will connect to each type of SQL
Server.
http://www.microsoft.com/windowsserv.../overview.mspx
"While compatible with 32-bit applications and existing deployment and
management tools, Windows XP Professional x64 Edition provides more
efficient processing of extremely large amounts of data, supporting up to 16
terabytes of virtual memory."
thanks,
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/
"kwl88" <kwl88@.discussions.microsoft.com> wrote in message
news:83D54961-0335-4642-8350-B14D9D78290B@.microsoft.com...[vbcol=seagreen]
> Keith:
> You would be incorrect!
> I recieve the following error message:
> "Error: %1 is not a valid Win32 application"
> It appears that I need to install a 32bit SQL Server Client. OR is there
> some workaround ou there?
> Thanks!
> "Keith Kratochvil" wrote:
|||The client tools, SSMS, SSIS, etc., are 32 bit applications, and are best
executed from 32 bit environments. They will operate from a 64 bit
environment using WOW, but at a performance penalty.
See: http://support.microsoft.com/kb/906892/
The 32 bit tools are, as far as I recall, located in a folder on the 64 bit
product disk. You may have to search around a bit.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"kwl88" <kwl88@.discussions.microsoft.com> wrote in message
news:83D54961-0335-4642-8350-B14D9D78290B@.microsoft.com...[vbcol=seagreen]
> Keith:
> You would be incorrect!
> I recieve the following error message:
> "Error: %1 is not a valid Win32 application"
> It appears that I need to install a 32bit SQL Server Client. OR is there
> some workaround ou there?
> Thanks!
> "Keith Kratochvil" wrote:
|||To clarify:
So I download and install for free the 32 bit Win server 2003 Eval copy and
install ONLY the client tools - Correct?
AND So do I eventually have to pay for these client tools? AND what about
the 4 CALS Licenses that I paid for? Will MS give me a refund for them?
What if I upgrade my .Net framework from 1.1 to 2.0 and then try to install
from my 64bit SQL Server install DVD might that work better?
Is there any documentation on this error on the internet? GOOD documentation?
Thanks!
Thanks!
"Warren Brunk" wrote:

> Just install the 32 bit client onto the client computer.
> I would download the 32 bit Windows Server 2005 Evaluation and just install
> the client tools.
> Both the 32 and 64 bit management studios will connect to each type of SQL
> Server.
> http://www.microsoft.com/windowsserv.../overview.mspx
> "While compatible with 32-bit applications and existing deployment and
> management tools, Windows XP Professional x64 Edition provides more
> efficient processing of extremely large amounts of data, supporting up to 16
> terabytes of virtual memory."
> thanks,
> --
> /*
> Warren Brunk - MCITP - SQL 2005, MCDBA
> www.techintsolutions.com
> */
>
> "kwl88" <kwl88@.discussions.microsoft.com> wrote in message
> news:83D54961-0335-4642-8350-B14D9D78290B@.microsoft.com...
>
>
|||It makes sense that the 32-bit client tools are on the 64-bit disc, as Arnie
mentioned.
I thought that the minimum # of CALs that could be acquired when you
purchase SQL Server was 5. How did you only purchase 4?
Regarding the 4 CALs - are you the only person/entity/computer connecting to
the database server? If so, you purchased too many licenses anyway...
Keith Kratochvil
"kwl88" <kwl88@.discussions.microsoft.com> wrote in message
news:77F66625-2146-465E-8137-5A340FFB2C7A@.microsoft.com...
> To clarify:
> So I download and install for free the 32 bit Win server 2003 Eval copy
> and
> install ONLY the client tools - Correct?
> AND So do I eventually have to pay for these client tools? AND what about
> the 4 CALS Licenses that I paid for? Will MS give me a refund for them?
> What if I upgrade my .Net framework from 1.1 to 2.0 and then try to
> install
> from my 64bit SQL Server install DVD might that work better?
> Is there any documentation on this error on the internet? GOOD
> documentation?
> Thanks!
> Thanks!