Unable to connect to Reporting Services in Mngt Studio

  • 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 7 posts - 1 through 8 (of 8 total)

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