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.
--