Can I get URL for RS from database ReportServer?

Hi,
is there any way to get URL for RS from database ReportServer?
I looked through tables in this DB but didn't find anything helpful.
Thanks.
VictorDid you mean you want to know what URL the report server is using?
Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config
"Victor" wrote:
> Hi,
> is there any way to get URL for RS from database ReportServer?
> I looked through tables in this DB but didn't find anything helpful.
> Thanks.
> Victor
>|||Thanks, it has it.
But I need this to find URLs for all Reporting Services on the network. So
maybe this is not the best method.
Any other ideas?
Victor
"David Bienstock" wrote:
> Did you mean you want to know what URL the report server is using?
> Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config
> "Victor" wrote:
> > Hi,
> >
> > is there any way to get URL for RS from database ReportServer?
> >
> > I looked through tables in this DB but didn't find anything helpful.
> >
> > Thanks.
> > Victor
> >|||Download SQLH2 and its ReportingServices reports... neat stuff like
performance counters, uptime, and all in RS!
"Victor" wrote:
> Thanks, it has it.
> But I need this to find URLs for all Reporting Services on the network. So
> maybe this is not the best method.
> Any other ideas?
> Victor
> "David Bienstock" wrote:
> > Did you mean you want to know what URL the report server is using?
> >
> > Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\ReportServer\RSReportServer.config
> >
> > "Victor" wrote:
> >
> > > Hi,
> > >
> > > is there any way to get URL for RS from database ReportServer?
> > >
> > > I looked through tables in this DB but didn't find anything helpful.
> > >
> > > Thanks.
> > > Victor
> > >|||Thanks again. And again it won't work for me.
I need to do this during run time. I want to populate combo box on my form
with RS URLs even if there is only one RS on the network.
Victor
"David Bienstock" wrote:
> Download SQLH2 and its ReportingServices reports... neat stuff like
> performance counters, uptime, and all in RS!
> "Victor" wrote:
> > Thanks, it has it.
> >
> > But I need this to find URLs for all Reporting Services on the network. So
> > maybe this is not the best method.
> >
> > Any other ideas?
> >
> > Victor
> >
> > "David Bienstock" wrote:
> >
> > > Did you mean you want to know what URL the report server is using?
> > >
> > > Check C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > > Services\ReportServer\RSReportServer.config
> > >
> > > "Victor" wrote:
> > >
> > > > Hi,
> > > >
> > > > is there any way to get URL for RS from database ReportServer?
> > > >
> > > > I looked through tables in this DB but didn't find anything helpful.
> > > >
> > > > Thanks.
> > > > Victor
> > > >