Report Manager: Unable to communicate with report server. -- sql server reporting services

sql server reporting services : Report Manager: Unable to communicate with report server.

sleyhane NO[at]SPAM gmail.com
11/12/2004 3:51:41 PM

Hello,

I'm using forms authentication with Reporting Services for integration
within an application. The integration is working -- I'm able to
access reports server through URL access from the app, and any
attempts to access reports server before authenticating redirect the
user to the login page.

My problem is that Report Manager is not working. Any attempt to
access it yields the "Unable to communicate with report server. Please
verify that the report server is operational".

I've seen lots of references in posts to the error that I'm receiving
but none that have solved the problem for me. Most threads indicate
that it is a configuration file error.

I have gone over the MSDN article
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp)
tens of times to make sure I performed all the steps and to ensure
that all my configuration settings are correct.

All of my configuration settings for the reports server URL matches up
(and call the machine name not 'localhost').

Reports server seems to be working correctly. I can access it
directly from the URL. I'm also confident that my authentication
extension is working. When attempting to login to Report Manager, I
have verified that the 'LogonUser' web service call is being made and
returns true. The authentication ticket is being forwarded back to
the client browser.

Something must be configured incorrectly in Report Manager but there
are not that many settings and I've checked them all dozens of times!
;-)

One difference between my implementation and the sample is that I'm
using SSL to access the reports server everywhere. I'm assuming that
this would not cause problems for Report Manager. Does it?

I'd appreciate any help. Anyone have any ideas? Attached is the
trace of the error message from Report Manager's log.

Thanks,

Stefan

--
w3wp!ui!5a4!11/12/2004-18:09:20:: e ERROR: Unable to communicate with
report server. Please verify that the report server is operational.
w3wp!ui!5a4!11/12/2004-18:09:21:: e ERROR: HTTP status code --> 500
-------Details--------
CantCommunicateWithReportServerException: Unable to communicate with
report server. Please verify that the report server is operational.

at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
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.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!5a4!11/12/2004-18:09:23:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean
preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String

DC
11/16/2004 10:27:28 AM

I had the same problem but when I commented the <deny users="?"> line in the
web.config under the ReportServer folder, I was able to logon onto the
Report Manager using the same Forms auth. But now, the reports will not
work. If I undo the change, we are back to square one. Let me know if you
find a solution to this one.

DC

[quoted text, click to view]
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/ht
ml/ufairs.asp)
[quoted text, click to view]

vince
1/3/2005 10:02:31 AM

DC,

I saw your posting from November. Did you ever find a solution for
this? I have the same issue and it's driving me nuts. Every time I
want to use ReportManager I have to comment out the
deny user=? line in the web config. I assume this is due to my using
forms authentication and messing up a config file somehow...

Can any Forma auth users shed some light on this one?

thanks,

Vince
Thomson Delmar Learning

[quoted text, click to view]

sleyhane NO[at]SPAM gmail.com
1/3/2005 2:46:44 PM

I was able to find a workaround to the problem.

To get over the error that I had reported to you, I had to add the
following element to the ReportServer web.config file:


<location path="ReportService.asmx">
<system.web>
<authorization>
<allow users="?" />
</authorization>
</system.web>
</location>

It seems that Report Manager makes a call to the Report Server web
service on initialization. With only the "<deny users="?" />" rule
that was specified in the MSDN article
(http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp),
Report Manager was not authorized to contact the web service.

I worked with Microsoft partner services but I wasn't able to get
confirmation that my assumption was correct. My support contact was
not able to duplicate the problem using the sample forms authentication
app.

Good luck,

Stefan Leyhane
Firmwater Inc.

vince
1/4/2005 6:43:11 AM

Thanks! I really appreciate your tip- this problem was really
bothering me. I thought I must have messed up a config file- I guess I
put to much trust in that Microsoft Whitepaper
having complete directions. If you're listening, MS, please add this
to the Whitepaper. I was on the verge of giving up on Report
Services...

[quoted text, click to view]

Jessica Landisman
5/6/2005 6:06:01 AM

Where in the nesting of the web.config did you place this additional
configuration information?

Also, are you using IP address or machine name when specifying the
ReportServerUrl in rsWebApp.config for ReportManager?
Thanks,
Jessica

[quoted text, click to view]

Sidat Hyder, Shimail Ahmed Gillani
6/1/2005 3:49:09 PM

Hello Guys AoA!

The only thing i had to do is as follows:

1) Open configuration file as C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager\RSWebApplication.config in
NotePad.Exe

2) ReportingServices by default install as :

<UI>
<ReportServerUrl>
http://localhost/ReportServer
</ReportServerUrl>
</UI>

3) Check about your directory structure , replace it if it is different from
yours.

4) Save and browse for report manager it should work now.

5) Best of luck

Thanks, Regards and AH

--
Allah Pakistan Ki Hifazat Farmay

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

home · blog · groups

Questions? Comments? Contact the dn