How to use rsUtility with Forms Authentication?

I have enabled Forms Authentication on Reporting Services. Everything is
working ok in Report Manager and Report Server. I was trying to script out
some administrative tasks using rs Utility. But I could not get connected to
the reportserver from rs Utility.
The command I was trying was:
rs -i test.rss -s "http://sqt-lt015/reportserver" -u username -p password
The trace information is as follows:
System.Exception: Could not connect to server:
http://sqt-lt015/reportserver/ReportService.asmx
at
Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
ty()
at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[] args,
Bas
eCmdLine instance)
I have confirmed that the report service link works ok in the browser. Any
ideas what's missing?
Thanks
YogeshI am having the same error:
Could not connect to server:
http://machinename/reportserver/ReportService.asmx
Does anyone have a working example of the rs utility with Forms
Authentication?
I have forms authentication working -- with the Report Manager, and calling
http://machinename/reportserver directly. I can reach
http://machinename/reportserver/ReportService.asmx directly with the browser
(no prompt for credentials there).
The code I am using looks like this:
Public Sub Main()
rs.Credentials = New System.Net.NetworkCredential("username",
"password")
'Create the shared data sources
CreateDataSource("servername", "databasename", "dbuser", "dbpass")
'''etc. (code based on Sample script PublishSampleReports.rss
--
But I don't think it's even getting to the code. Any help would be welcome,
thanks.
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"yogeshprabhu" <yogeshprabhu@.discussions.microsoft.com> wrote in message
news:A2C8800E-BA82-424A-899F-41B4BE08C0CB@.microsoft.com...
>I have enabled Forms Authentication on Reporting Services. Everything is
> working ok in Report Manager and Report Server. I was trying to script out
> some administrative tasks using rs Utility. But I could not get connected
> to
> the reportserver from rs Utility.
> The command I was trying was:
> rs -i test.rss -s "http://sqt-lt015/reportserver" -u username -p password
>
> The trace information is as follows:
> System.Exception: Could not connect to server:
> http://sqt-lt015/reportserver/ReportService.asmx
> at
> Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
> ty()
> at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
> at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
> args,
> Bas
> eCmdLine instance)
>
> I have confirmed that the report service link works ok in the browser. Any
> ideas what's missing?
>
> Thanks
>
> Yogesh
>
>
>|||Hi Jeff,
Although not documented by Microsoft, I have come to conclusion that rs
utility works only with Windows authentication. If you have implemented Forms
Authentication based on the white paper on MSDN then refer to the code of the
ReportServer proxy class, it creates the necessary cookie for Forms
Authentication to work. I believe this white paper was released after
releasing SQL RS, and may be that's the reason rs utility is not supporting
this security extension. I however don't understand how would Visual
Studio.NET handle this extension. If you try to deploy reports using VS.NET
on report server that is enabled for Forms Authentication then it prompts a
dialog box where you can enter username and password.
I started researching for rs utiltiy earlier because VS.NET deployment did
not let me create linked reports. I finally ended up creating a C# based
console application, added a web reference to ReportService.asmx, and used
web methods to create folders, deploy reports, and create linked reports. I
borrowed proxy class code from Forms Authentication sample and tweaked it a
little bit to pass on auth cookie with each method call.
Yogesh
"Jeff A. Stucker" wrote:
> I am having the same error:
> Could not connect to server:
> http://machinename/reportserver/ReportService.asmx
> Does anyone have a working example of the rs utility with Forms
> Authentication?
> I have forms authentication working -- with the Report Manager, and calling
> http://machinename/reportserver directly. I can reach
> http://machinename/reportserver/ReportService.asmx directly with the browser
> (no prompt for credentials there).
> The code I am using looks like this:
> Public Sub Main()
> rs.Credentials = New System.Net.NetworkCredential("username",
> "password")
> 'Create the shared data sources
> CreateDataSource("servername", "databasename", "dbuser", "dbpass")
> '''etc. (code based on Sample script PublishSampleReports.rss
> --
> But I don't think it's even getting to the code. Any help would be welcome,
> thanks.
> Cheers,
>
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "yogeshprabhu" <yogeshprabhu@.discussions.microsoft.com> wrote in message
> news:A2C8800E-BA82-424A-899F-41B4BE08C0CB@.microsoft.com...
> >I have enabled Forms Authentication on Reporting Services. Everything is
> > working ok in Report Manager and Report Server. I was trying to script out
> > some administrative tasks using rs Utility. But I could not get connected
> > to
> > the reportserver from rs Utility.
> >
> > The command I was trying was:
> >
> > rs -i test.rss -s "http://sqt-lt015/reportserver" -u username -p password
> >
> >
> > The trace information is as follows:
> >
> > System.Exception: Could not connect to server:
> > http://sqt-lt015/reportserver/ReportService.asmx
> > at
> > Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
> > ty()
> > at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
> > args,
> > Bas
> > eCmdLine instance)
> >
> >
> >
> > I have confirmed that the report service link works ok in the browser. Any
> > ideas what's missing?
> >
> >
> > Thanks
> >
> >
> >
> > Yogesh
> >
> >
> >
> >
> >
>
>|||Thanks, that looks like what we'll have to do.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"yogeshprabhu" <yogeshprabhu@.discussions.microsoft.com> wrote in message
news:F5AD9553-8ACD-4D4B-B408-C0EAD2C8B7ED@.microsoft.com...
> Hi Jeff,
> Although not documented by Microsoft, I have come to conclusion that rs
> utility works only with Windows authentication. If you have implemented
> Forms
> Authentication based on the white paper on MSDN then refer to the code of
> the
> ReportServer proxy class, it creates the necessary cookie for Forms
> Authentication to work. I believe this white paper was released after
> releasing SQL RS, and may be that's the reason rs utility is not
> supporting
> this security extension. I however don't understand how would Visual
> Studio.NET handle this extension. If you try to deploy reports using
> VS.NET
> on report server that is enabled for Forms Authentication then it prompts
> a
> dialog box where you can enter username and password.
> I started researching for rs utiltiy earlier because VS.NET deployment did
> not let me create linked reports. I finally ended up creating a C# based
> console application, added a web reference to ReportService.asmx, and used
> web methods to create folders, deploy reports, and create linked reports.
> I
> borrowed proxy class code from Forms Authentication sample and tweaked it
> a
> little bit to pass on auth cookie with each method call.
> Yogesh
> "Jeff A. Stucker" wrote:
>> I am having the same error:
>> Could not connect to server:
>> http://machinename/reportserver/ReportService.asmx
>> Does anyone have a working example of the rs utility with Forms
>> Authentication?
>> I have forms authentication working -- with the Report Manager, and
>> calling
>> http://machinename/reportserver directly. I can reach
>> http://machinename/reportserver/ReportService.asmx directly with the
>> browser
>> (no prompt for credentials there).
>> The code I am using looks like this:
>> Public Sub Main()
>> rs.Credentials = New System.Net.NetworkCredential("username",
>> "password")
>> 'Create the shared data sources
>> CreateDataSource("servername", "databasename", "dbuser", "dbpass")
>> '''etc. (code based on Sample script PublishSampleReports.rss
>> --
>> But I don't think it's even getting to the code. Any help would be
>> welcome,
>> thanks.
>> Cheers,
>>
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "yogeshprabhu" <yogeshprabhu@.discussions.microsoft.com> wrote in message
>> news:A2C8800E-BA82-424A-899F-41B4BE08C0CB@.microsoft.com...
>> >I have enabled Forms Authentication on Reporting Services. Everything is
>> > working ok in Report Manager and Report Server. I was trying to script
>> > out
>> > some administrative tasks using rs Utility. But I could not get
>> > connected
>> > to
>> > the reportserver from rs Utility.
>> >
>> > The command I was trying was:
>> >
>> > rs -i test.rss -s "http://sqt-lt015/reportserver" -u username -p
>> > password
>> >
>> >
>> > The trace information is as follows:
>> >
>> > System.Exception: Could not connect to server:
>> > http://sqt-lt015/reportserver/ReportService.asmx
>> > at
>> > Microsoft.ReportingServices.ScriptHost.ScriptHost.DetermineServerUrlSecuri
>> > ty()
>> > at Microsoft.ReportingServices.ScriptHost.ScriptHost.InstanceMain()
>> > at Microsoft.ReportingServices.BaseCmdLine.CommandLineMain(String[]
>> > args,
>> > Bas
>> > eCmdLine instance)
>> >
>> >
>> >
>> > I have confirmed that the report service link works ok in the browser.
>> > Any
>> > ideas what's missing?
>> >
>> >
>> > Thanks
>> >
>> >
>> >
>> > Yogesh
>> >
>> >
>> >
>> >
>> >
>>