Unable to connect to Reporting Services in Mngt Studio

  • All,

    While trying to access the Reporting Services in Mng studio.I receive the following error

    Cannot Connect To ServerA

    Client found response content type of 'text/html; charset=uf-8,but expected 'text/xml' -error is attached below

    While trying to access the report on reportmanager.I receive an error."The report server is not responding.Verify that the report server is running and can be accessed from this computer"

    Any suggestion?

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • This are my findings in the error log.Anybody out there encounter this before ?

    w3wp!library!1!04/25/2008-09:33:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.

    at Microsoft.ReportingServices.Library.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

    at Microsoft.ReportingServices.Library.WebConfigUtil.GetAuthenticationType()

    at Microsoft.ReportingServices.Library.WebConfigUtil.get_UsingWindowsAuth()

    at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

    at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)

    --- End of inner exception stack trace ---

    w3wp!library!6!04/25/2008-09:33:26:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

    w3wp!library!6!04/25/2008-09:33:27:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.NullReferenceException: Object reference not set to an instance of an object.

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • Check your web.config file in report server directory and see if you see anything like this

    and change it to

    Try this out if it helps!!!

    Prasad Bhogadi
    www.inforaise.com

  • Hi Prasad,

    It would be grateful if yu could tell me which parameter that I should change in the webconfig file.Thanks

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • Just you need to verify if your web.config file under Report Server and Report Manager have any xmlns links inside the Configuration tag and remove them.

    configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" then change it to configuration (enclosed in less than and greater than tags)

    I believe the editor is not allowing text enclosed inside less than and greater than tags, so I removed them.

    Prasad Bhogadi
    www.inforaise.com

  • Prasad Bhogadi (4/25/2008)


    Just you need to verify if your web.config file under Report Server and Report Manager have any xmlns links inside the Configuration tag and remove them.

    configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0" then change it to configuration (enclosed in less than and greater than tags)

    I believe the editor is not allowing text enclosed inside less than and greater than tags, so I removed them.

    You need to use the html encoding for < and >

  • Hi Prasad,

    Thank you very much.Now it works well. I compared my webconfig file with other working servers and editted the changes.

    Could you briefly explain the possible reason for this problem.

    [font="TimesNewRoman"] “I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison[/font]

  • The simple solution is to go

    Report Services Configuration-> Server status and reset your intialization.

    It will work now.

    Regards,

    Tariq Younas

    INTECH PROCESS AUTOMTION

    http://www.intechww.com

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply