SQL Server Performance

deploy a report to report server in SQL 2k5

Discussion in 'SQL Server 2005 Integration Services' started by supernova122, Oct 14, 2007.

  1. supernova122 New Member

    I have made a report using Business Intelligence Development Studio in
    SQL2005. When I deploy that report the report server, I got the error:

    ****************************************************************************************************************************
    A connection cannot not be made to the report server
    http://servername.

    Addition Information:

    The server committed a protocol violation. Section=ResponseHeader detail=CR
    must be followed by LF (System.Web.Service)

    ******************************************************************************************************************************************************

    Then I use IE to open http://servername/reportserver , I get the following
    message:



    Server Error in '/ReportServer' Application.
    --------------------------------------------------------------------------------

    Runtime Error
    Description: An application error occurred on the server. The current custom
    error settings for this application prevent the details of the application
    error from being viewed remotely (for security reasons). It could, however,
    be viewed by browsers running on the local server machine.

    Details: To enable the details of this specific error message to be viewable
    on remote machines, please create a <customErrors> tag within a "web.config"
    configuration file located in the root directory of the current web
    application. This <customErrors> tag should then have its "mode" attribute
    set to "Off".

    <!-- Web.Config Configuration File -->

    <configuration>
    <system.web>
    <customErrors mode="Off"/>
    </system.web>
    </configuration>

    Notes: The current error page you are seeing can be replaced by a custom
    error page by modifying the "defaultRedirect" attribute of the application's
    <customErrors> configuration tag to point to a custom error page URL.

    <!-- Web.Config Configuration File -->

    <configuration>
    <system.web>
    <customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>
    </system.web>
    </configuration>

  2. satya Moderator

    The problem is that the HTTP response has an HTTP protocol violation in it. The .NET Framework is by default very strict about ensuring that the HTTP headers are formatted correctly.
    You might need to contact your Security team in this regard.
    Are the both environments are same, I mean where you have designed this report and deploying currently and in this case you simply need to set the Url property of your proxy class. Refer to http://msdn2.microsoft.com/en-us/library/system.web.services.protocols.webclientprotocol.url.aspx link.
  3. dineshasanka Moderator

    Have you configured vitual server for report server
  4. supernova122 New Member

    In fact, I used report services configuration manager and clicked new button for both creating report server and report manager virtual directory. But it failed and gives an error: "The virtual directory cannot be created. The previously set virtual directory will still be used."
    "ReportServicesConfigUI.WMIProvider.WMIProviderException: The virtual directory specified already exists. Specify a different name.at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.CreateVirtualDirectory(String virtualDirectory, String path)"
    Please help how to proceed. Thanks.
  5. dineshasanka Moderator

Share This Page