all groups > sql server reporting services > august 2007 >
You're in the

sql server reporting services

group:

Reporting Services Forms Authentication in a Server Farm environme


Reporting Services Forms Authentication in a Server Farm environme Tristan
8/30/2007 12:04:00 PM
sql server reporting services:
Hello,

I am trying to set up SQL Server Reporting Services in a dual server
environment. There are two machines, app01 and app02, each running the
Report Manager and the Report Server. These two machines sit behind a
context switch, so that you may type in a virtual address such as
"www.reports.com" and the request will be redirected to one of the two
machines.

At the moment, I am simply trying to get the Forms Authentication example
that you can install along with SQL Server 2005 to work. I have been able to
get the example to work on each machine individually. In other words, if you
use your browser to go to the report server directly, the login page is
displayed and upon successful authentication, the user is redirected to the
Report Manager. However, when I attempt to access the application from the
virtual URL, I recieve the logon page an can never get past it. I am not
exactly sure what is happening, but when I fill in a valid username and
password and submit, I am redirected to the exact same page.

I checked the log files on the machine and I would image that this error
message is evidence of the problem I am having

3wp!ui!5!8/30/2007-11:23:04:: i INFO: Overwriting existing cookie
w3wp!ui!5!8/30/2007-11:23:04:: e ERROR: The report server is not responding.
Verify that the report server is running and can be accessed from this
computer.
w3wp!ui!5!8/30/2007-11:23:04:: e ERROR: HTTP status code --> 500
-------Details--------
Microsoft.ReportingServices.UI.Global+RSWebServiceWrapper+CantCommunicateWithReportServerException:
The report server is not responding. Verify that the report server is running
and can be accessed from this computer.

at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()

at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)

at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()

at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)

at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)

at System.EventHandler.Invoke(Object sender, EventArgs e)

at System.Web.UI.Control.OnInit(EventArgs e)

at System.Web.UI.Page.OnInit(EventArgs e)

at System.Web.UI.Control.InitRecursive(Control namingContainer)

at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


I do not know how to resolve this issue. Advice would be greatly appreciated.

--
RE: Reporting Services Forms Authentication in a Server Farm environme XtremeGod
10/7/2007 9:45:00 PM
Hi All,

We are having a similar problem. Has anyone found out a way around this.
I suspect its related to cookies and the domain etc they are attached to but
have not been
able to find a way around this problem yet?

Any help would be appreciated.

Thanks
Rick

[quoted text, click to view]
RE: Reporting Services Forms Authentication in a Server Farm envir Tristan
10/8/2007 10:31:00 AM
Hi,

I have since resolved the problem I was having. I don't know if this
solution will work for your situation, but its simple enough to try, so it is
probably worth a shot.

The dual app servers that we are using are sitting behind a "round-robin"
switch hosted at something like www.reports.com. The switch will redirect
any given request to either www.reports1.com or www.reports2.com, and it does
so randomly.

The fix that I employed involded going to the "host" file on both of the
machines and mapping all requests to the local machine back out to the
virtual url (www.reports.com). In other words I added these entries to the
host files of the two different machines:

machine 1:
127.0.0.1 www.reports.com

machine 2:
127.0.0.1 www.reports.com

The host file is typically located at %SystemRoot%\system32\drivers\etc\

See http://en.wikipedia.org/wiki/Host_file for other common locations.

Hope this helps.

-Tristan

--
Tristan


[quoted text, click to view]
AddThis Social Bookmark Button