Monday, February 20, 2012

MS Reporting on internet with Forms Authentication

Could anyone tell me if you have had any success and are currently
running MS Reporting Services on the Internet with Forms
Authentication, using the Ufairs example from Microsoft?
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
Can you actually do this? I can make this work on my intranet, but
unfortunately, I have been unable to make the transition to the
Internet. If you have been able to make this work, here is my problem.
When I am in the ulogin web page and enter in the correct username and
password, I am returned back to the ulogin page. I think this is a
cookie issue. I have been working with Microsoft support for this, but
have been unable to make this work.
Any suggestion? Any help will be greatly appreciated.
Thank you for your time in advance.Daniel - I don't believe that being returned to the login page mean you have
an issue if you are attempting the url http://localhost/reports/, try
http://localhost/reports/Pages/Folder.aspx and you should be ok
Hope this helps,
Michael
"Daniel" wrote:
> Could anyone tell me if you have had any success and are currently
> running MS Reporting Services on the Internet with Forms
> Authentication, using the Ufairs example from Microsoft?
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> Can you actually do this? I can make this work on my intranet, but
> unfortunately, I have been unable to make the transition to the
> Internet. If you have been able to make this work, here is my problem.
> When I am in the ulogin web page and enter in the correct username and
> password, I am returned back to the ulogin page. I think this is a
> cookie issue. I have been working with Microsoft support for this, but
> have been unable to make this work.
> Any suggestion? Any help will be greatly appreciated.
> Thank you for your time in advance.
>|||Michael
Thank you for your quick response. I made sure I was calling with the
"/Pages/Folder.aspx" added on with the same results.
The only difference was I called via the Internet(which is my issue,
not the Intranet)
http://www.mywebsite.com/reports/Pages/Folder.aspx
Any other ideas? I am truely lost here trying to make this work.
Again, Thank you all for any help.
Michael Nichols wrote:
> Daniel - I don't believe that being returned to the login page mean
you have
> an issue if you are attempting the url http://localhost/reports/, try
> http://localhost/reports/Pages/Folder.aspx and you should be ok
> Hope this helps,
> Michael
> "Daniel" wrote:
> > Could anyone tell me if you have had any success and are currently
> > running MS Reporting Services on the Internet with Forms
> > Authentication, using the Ufairs example from Microsoft?
> >
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> >
> > Can you actually do this? I can make this work on my intranet, but
> > unfortunately, I have been unable to make the transition to the
> > Internet. If you have been able to make this work, here is my
problem.
> >
> > When I am in the ulogin web page and enter in the correct username
and
> > password, I am returned back to the ulogin page. I think this is a
> > cookie issue. I have been working with Microsoft support for this,
but
> > have been unable to make this work.
> >
> > Any suggestion? Any help will be greatly appreciated.
> >
> > Thank you for your time in advance.
> >
> >|||Daniel - I'm not sure if this will help you, but my last post should have
been to change the url to: http://<your
server>/Reports/Pages/Folder.aspx?ViewMode=List.
While I implemented this on our Intranet, I have not implemented this on the
Internet, so you may be dealing with an issue different then I encountered.
"Daniel" wrote:
> Michael
> Thank you for your quick response. I made sure I was calling with the
> "/Pages/Folder.aspx" added on with the same results.
> The only difference was I called via the Internet(which is my issue,
> not the Intranet)
> http://www.mywebsite.com/reports/Pages/Folder.aspx
> Any other ideas? I am truely lost here trying to make this work.
> Again, Thank you all for any help.
>
>
>
> Michael Nichols wrote:
> > Daniel - I don't believe that being returned to the login page mean
> you have
> > an issue if you are attempting the url http://localhost/reports/, try
> > http://localhost/reports/Pages/Folder.aspx and you should be ok
> >
> > Hope this helps,
> > Michael
> > "Daniel" wrote:
> >
> > > Could anyone tell me if you have had any success and are currently
> > > running MS Reporting Services on the Internet with Forms
> > > Authentication, using the Ufairs example from Microsoft?
> > >
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> > >
> > > Can you actually do this? I can make this work on my intranet, but
> > > unfortunately, I have been unable to make the transition to the
> > > Internet. If you have been able to make this work, here is my
> problem.
> > >
> > > When I am in the ulogin web page and enter in the correct username
> and
> > > password, I am returned back to the ulogin page. I think this is a
> > > cookie issue. I have been working with Microsoft support for this,
> but
> > > have been unable to make this work.
> > >
> > > Any suggestion? Any help will be greatly appreciated.
> > >
> > > Thank you for your time in advance.
> > >
> > >
>|||Michael,
I changed my url and was still was redirected to the "UILogon.aspx"
page.
I thought this was a cookie issue, and somewhat still do. But I read an
article on a TCP sniffer
(http://www.devx.com/dotnet/Article/27133/0/page/5) and tried tcptrace
program (http://www.pocketsoap.com/tcptrace/).
When I run the internet version www.mywebsite.com/reports, I see the
cookie
Cookie:
sqlAuthCookie=C8E363B83D175024F7E26E07AEF5D9B9DDD62ECB2A66ACA884D02455BA3F198013694C187FC3059544B83E3F731351376669B8501DE866EAB97B51375FDD8867308454050AE23350
Thank you Michael for you insight.
If anyone has any success in making this work, I would deeply
appreciate you assistance.
Thank you
Daniel
Michael Nichols wrote:
> Daniel - I'm not sure if this will help you, but my last post should
have
> been to change the url to: http://<your
> server>/Reports/Pages/Folder.aspx?ViewMode=List.
> While I implemented this on our Intranet, I have not implemented this
on the
> Internet, so you may be dealing with an issue different then I
encountered.
>
>
> "Daniel" wrote:
> > Michael
> >
> > Thank you for your quick response. I made sure I was calling with
the
> > "/Pages/Folder.aspx" added on with the same results.
> >
> > The only difference was I called via the Internet(which is my
issue,
> > not the Intranet)
> >
> > http://www.mywebsite.com/reports/Pages/Folder.aspx
> >
> > Any other ideas? I am truely lost here trying to make this work.
> >
> > Again, Thank you all for any help.
> >
> >
> >
> >
> >
> >
> >
> > Michael Nichols wrote:
> > > Daniel - I don't believe that being returned to the login page
mean
> > you have
> > > an issue if you are attempting the url http://localhost/reports/,
try
> >
> > > http://localhost/reports/Pages/Folder.aspx and you should be ok
> > >
> > > Hope this helps,
> > > Michael
> > > "Daniel" wrote:
> > >
> > > > Could anyone tell me if you have had any success and are
currently
> > > > running MS Reporting Services on the Internet with Forms
> > > > Authentication, using the Ufairs example from Microsoft?
> > > >
> >
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs_topic3
> > > >
> > > > Can you actually do this? I can make this work on my intranet,
but
> > > > unfortunately, I have been unable to make the transition to the
> > > > Internet. If you have been able to make this work, here is my
> > problem.
> > > >
> > > > When I am in the ulogin web page and enter in the correct
username
> > and
> > > > password, I am returned back to the ulogin page. I think this
is a
> > > > cookie issue. I have been working with Microsoft support for
this,
> > but
> > > > have been unable to make this work.
> > > >
> > > > Any suggestion? Any help will be greatly appreciated.
> > > >
> > > > Thank you for your time in advance.
> > > >
> > > >
> >
> >|||Oh,
I would like to point out while you guys think of anything, I can go to
http://www.mywebsite.com/Reportserver , enter in the username and
password and the redirect works like a champ. I can see the
reportserver listing.
More confused than ever...Of course any ideas would be helpful.
<<Knocks on the reporting services development team's door and hopes
someone will answer>>|||Daniel,
I am running into this exact issue, Were you able to resolve this,
I think your guess is correct IE somehow does not pass the cookie(only reason
would be it it sees them as different domains)
Let me know if you can,
thanks,
Rakesh
"Daniel" wrote:
> Oh,
> I would like to point out while you guys think of anything, I can go to
> http://www.mywebsite.com/Reportserver , enter in the username and
> password and the redirect works like a champ. I can see the
> reportserver listing.
> More confused than ever...Of course any ideas would be helpful.
> <<Knocks on the reporting services development team's door and hopes
> someone will answer>>
>|||Rakesh
Thank you for your interest in this issue. I know I am not the only one
out there trying to make Reporting Services work in the Internet with
Forms Authentication. I feel confident that someone has made this
function.
I am currently working with Microsoft on this issue. As a matter of
fact, I just got off the phone with a manager in the Reporting Services
Support group. I should have some word tomorrow. When I find something
out, I will post here to help others. I know frustrating feeling you
are having with this problem. Hopefully through the trials and
tribulations I am going thru, I can smooth out your troubles a bit.
In the meantime, if anyone has any suggestions please feel free to
post.
Thank you!
Danny|||2 places I think control this behavior: The Webapplication.confi
loginUrl and the IIS virtual directory properties for defaul
content
You will need to adjust these until you find the right mix
Chances are you want the virtual directory default content pointed t
your login page and try the home.aspx page for your loginurl in th
webapplication.config setting

No comments:

Post a Comment