Retrieve URL for ReportingServices Web Service.

Hi
I need to be able to retrieve the URL for the ReportingServices Web Service
programmatically. Is this possible?
I am currently updating a reporting services deployment tool for SQL 2005
and 2008, in my old version (SQL Server 2003) the Web Service was almost
always guaranteed to be http://<server>/ReportServer/ReportService.asmx,
however with the latest version of SQL and Reporting Services Configuration
Manager this is not always be the case.
I have the sql server name that I want to deploy to but I can see no way of
getting the URL to the ReportingServices Web Service to do the deployment.
Any ideas?On Jan 7, 10:09 am, Busby <Bu...@.discussions.microsoft.com> wrote:
> Hi
> I need to be able to retrieve the URL for the ReportingServices Web Service
> programmatically. Is this possible?
> I am currently updating a reporting services deployment tool for SQL 2005
> and 2008, in my old version (SQL Server 2003) the Web Service was almost
> always guaranteed to be http://<server>/ReportServer/ReportService.asmx,
> however with the latest version of SQL and Reporting Services Configuration
> Manager this is not always be the case.
> I have the sql server name that I want to deploy to but I can see no way of
> getting the URL to the ReportingServices Web Service to do the deployment.
> Any ideas?
This is just a thought, but you could try adding a web reference to a
custom ASP.NET application for the report server and check that
reference path. Normally, the URL path for SSRS 2005 is here:
http://myserver/reportserver/ReportExecution2005.asmx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique
That would work if I knew which server I want to deploy to, however my
application allows the users to deploy to multiple servers.
I initially query instances of SQL server on the network, I then allow the
users to select a number of reports which I will then create on the report
server. Finally I will change each deployed reports data source to point to
the selected sql server.
This worked fine for SQL 2000 where the web service for reporting services
was static, however for 2005 and 2008 the web services url can change
depending on how its configured via the Reporting Services Configuration
utility.
I think the only way I can do this is to query IIS to get a list of web
sites/services and check that the url ends with ReportService.asmx.
Anyone agree? Or have better solution?
"EMartinez" wrote:
> On Jan 7, 10:09 am, Busby <Bu...@.discussions.microsoft.com> wrote:
> > Hi
> >
> > I need to be able to retrieve the URL for the ReportingServices Web Service
> > programmatically. Is this possible?
> >
> > I am currently updating a reporting services deployment tool for SQL 2005
> > and 2008, in my old version (SQL Server 2003) the Web Service was almost
> > always guaranteed to be http://<server>/ReportServer/ReportService.asmx,
> > however with the latest version of SQL and Reporting Services Configuration
> > Manager this is not always be the case.
> >
> > I have the sql server name that I want to deploy to but I can see no way of
> > getting the URL to the ReportingServices Web Service to do the deployment.
> >
> > Any ideas?
>
> This is just a thought, but you could try adding a web reference to a
> custom ASP.NET application for the report server and check that
> reference path. Normally, the URL path for SSRS 2005 is here:
> http://myserver/reportserver/ReportExecution2005.asmx
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Jan 8, 2:55 am, Busby <Bu...@.discussions.microsoft.com> wrote:
> Hi Enrique
> That would work if I knew which server I want to deploy to, however my
> application allows the users to deploy to multiple servers.
> I initially query instances of SQL server on the network, I then allow the
> users to select a number of reports which I will then create on the report
> server. Finally I will change each deployed reports data source to point to
> the selected sql server.
> This worked fine for SQL 2000 where the web service for reporting services
> was static, however for 2005 and 2008 the web services url can change
> depending on how its configured via the Reporting Services Configuration
> utility.
> I think the only way I can do this is to query IIS to get a list of web
> sites/services and check that the url ends with ReportService.asmx.
> Anyone agree? Or have better solution?
> "EMartinez" wrote:
> > On Jan 7, 10:09 am, Busby <Bu...@.discussions.microsoft.com> wrote:
> > > Hi
> > > I need to be able to retrieve the URL for the ReportingServices Web Service
> > > programmatically. Is this possible?
> > > I am currently updating a reporting services deployment tool for SQL 2005
> > > and 2008, in my old version (SQL Server 2003) the Web Service was almost
> > > always guaranteed to be http://<server>/ReportServer/ReportService.asmx,
> > > however with the latest version of SQL and Reporting Services Configuration
> > > Manager this is not always be the case.
> > > I have the sql server name that I want to deploy to but I can see no way of
> > > getting the URL to the ReportingServices Web Service to do the deployment.
> > > Any ideas?
> > This is just a thought, but you could try adding a web reference to a
> > custom ASP.NET application for the report server and check that
> > reference path. Normally, the URL path for SSRS 2005 is here:
> >http://myserver/reportserver/ReportExecution2005.asmx
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
That sounds like the most direct approach. Otherwise, you might need
to design some sort of RS Web Service WSDL discovery application that
dynamically polls the servers with typical URL patterns. Sorry that I
could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant