SQL Server 2008 Reporting Services Authentication

Question

<Authentication>
    <AuthenticationTypes>
        <RSWindowsNTLM/>
    </AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>

Whenever I have the above settings in my rsreportserver.config file, I can view reports in my web application, but I can not access the report manager.

But whenever I have the settings below, I cannot view reports in my web application, but I can access the report manager. What options should be used to access both?

<Authentication>
    <AuthenticationTypes>
        <RSWindowsBasic/>
    </AuthenticationTypes>
<EnableAuthPersistence>true</EnableAuthPersistence>
</Authentication>

Answer 1

I’m sure that you have already seen these items, but I thought that I would go just in case if they would be useful or if someone else needed:

http://blogs.msdn.com/brianhartman/archive/2008/11/21/custom-credentials-in-the-report-viewer.aspx

http://blogs.msdn.com/jameswu/archive/2008/07/15/anonymous-access-in-sql-rs-2008.aspx

http://technet.microsoft.com/en-us/library/ms159272%28SQL.90%29.aspx

http://blogs.msdn.com/microsoftbob/archive/2009/08/20/a-wrapper-for-running-sql-server-2008-reporting-services-reports-anonymously.aspx