none
reporitng service credential access issue. RRS feed

  • Question

  • Hi 

    We connect to Reporting Server from ASP.NET application using Reporting service. 

    We are facing intermittent issues when we try to connect to Report server. (SQL server 2016).  On checking logs of Report server, we noticed that 

    that sometimes application or app pool access  as user and sometimes as NT Authority\Networkservices. 

     Following is code  we use to pass credentials

      ReportExecutionService rptExeSvc = new ReportExecutionService();
                    rptExeSvc.Credentials = System.Net.CredentialCache.DefaultCredentials;

    & in web.config we have


            <value>http://servername/ReportServer/ReportExecution2005.asmx</value>
       

    We cannot enable service account because of security compliance issue. Could you please let me help me to resolve this

    System.Net.CredentialCache.DefaultCredentials; still ok.

    We migrated from SQL 2012 to 2016 and for compliance purpose are restricing use of service account and prefer machine account for server to server access.

    Friday, March 20, 2020 6:20 PM