Groups | Blog | Home
all groups > sql server reporting services > may 2005 >

sql server reporting services : MS Reporting on internet with Forms Authentication



Daniel
5/16/2005 11:10:47 AM
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 Nichols
5/16/2005 1:31:01 PM
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
[quoted text, click to view]
Daniel
5/16/2005 3:09:19 PM
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.







[quoted text, click to view]
Michael Nichols
5/17/2005 7:20:05 AM
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.




[quoted text, click to view]
Daniel
5/17/2005 7:37:37 AM
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




[quoted text, click to view]
Daniel
5/17/2005 12:23:30 PM
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
5/25/2005 10:13:01 AM
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

[quoted text, click to view]
Daniel
6/2/2005 9:18:37 AM
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
sidneyljohnson NO[at]SPAM sbcglobal-dot-net.no-spam.invalid
7/30/2005 1:08:56 AM
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
AddThis Social Bookmark Button