Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Reporting Services unauthorized problem on Windows server 2008

Unanswered SQL Reporting Services unauthorized problem on Windows server 2008

  • Thursday, January 10, 2013 11:30 AM
     
     
    Sign In to Vote
    0

    I have SQL Server 2008 on window server 2008 that is my report server.

    My web application is in vs2010 which is on the other system. When I tried to show the report in report viewer it giving the following error:  The request failed with HTTP status 401: Unauthorized.

    I used the ProcessingMode.Remote.

    I want to use the database credential for accessing the report (please keep in mind that I don’t want to use windows credential).

    I have set the following authentication in reportserver.config file.

    <Authentication>

                <AuthenticationTypes>

                      <RSWindowsNegotiate/>

                      <RSWindowsNTLM/>

                </AuthenticationTypes>

                <EnableAuthPersistence>true</EnableAuthPersistence>

          </Authentication>

    And on data source I have selected the “Credential stored securely in the report server” option.

    More over when I use the window server 2003 report server its working fine and report viewer showing the report successfully, It create problem on window server 2008.

    Please someone help me to overcome this problem. Is report server required some specific configuration for window server 2008?   
     

All Replies

  • Thursday, January 10, 2013 11:27 AM
     
     
    Sign In to Vote
    0

    I have SQL Server 2008 on window server 2008 that is my report server.

    My web application is in vs2010 which is on the other system. When I tried to show the report in report viewer it giving the following error:  The request failed with HTTP status 401: Unauthorized.

    I used the ProcessingMode.Remote.

    I want to use the database credential for accessing the report (please keep in mind that I don’t want to use windows credential).

    I have set the following authentication in reportserver.config file.

    <Authentication>

                <AuthenticationTypes>

                      <RSWindowsNegotiate/>

                      <RSWindowsNTLM/>

                </AuthenticationTypes>

                <EnableAuthPersistence>true</EnableAuthPersistence>

          </Authentication>

    And on data source I have selected the “Credential stored securely in the report server” option.

    More over when I use the window server 2003 report server its working fine and report viewer showing the report successfully, It create problem on window server 2008.

    Please someone help me to overcome this problem. Is report server required some specific configuration for window server 2008?   

     
  • Monday, January 14, 2013 3:20 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Shabicool,

    The error indicates that the credentials were not passed to the report server properly. It might occur due to the Impersonate setting of the custom application or the settings of the stored SQL Server account credential. Here, I suggest that you refer to the following steps:

    1. In the web.config file of the custom application, if you have set the Impersonate to configuration, please comment out this section.
    2. On the report manager, configure the stored credentials of the data source, and try to check or uncheck the “Impersonate the authenticated user after a connection has been made to the data source” option after inputting the SQL Server credential.

    Hope this helps.

    Regards,

    Mike Yin
    TechNet Community Support