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.
--
TristanHi 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
"Tristan" wrote:
> 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.
> --
> Tristan|||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
"XtremeGod" wrote:
> 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
> "Tristan" wrote:
> > 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.
> >
> > --
> > Tristan
No comments:
Post a Comment