how to fix Failure authenticating with NTLM <any realm> in 2019 SSRS webservice

BBL 0 Reputation points
2023-02-20T15:53:45.96+00:00

Hello Team,

Recently we are migrating SSRS web service to 2019 to from 2008 SSRS web service. Geeting the below error

INFO: Failure authenticating with NTLM <any realm>@XXX
ERROR 06-02 14:11:11,959 - Axis Fault Exception occurred while getting report:
AxisFault
faultCode: {http://xml.apache.org/axis/}HTTP
faultSubcode: 
 faultString: (401)Unauthorized
faultActor: 
 faultNode: 
 faultDetail: 
               {}:return code:  401

               {http://xml.apache.org/axis/}HttpErrorCode:401

(401)Unauthorized
               at org.apache.axis.transport.http.CommonsHTTPSender.invoke(CommonsHTTPSender.java:218)
               at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
               at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
               at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
               at org.apache.axis.client.AxisClient.invoke(AxisClient.java:165)
               at org.apache.axis.client.Call.invokeEngine(Call.java:2784)
               at org.apache.axis.client.Call.invoke(Call.java:2767)
               at org.apache.axis.client.Call.invoke(Call.java:2443)
               at org.apache.axis.client.Call.invoke(Call.java:2366)
               at org.apache.axis.client.Call.invoke(Call.java:1812)
               at com.ng.services.reports.microsoft.schemas.sqlserver._2005._06._30.reporting.reportingservices.ReportExecutionServiceSoapStub.loadReport(ReportExecutionServiceSoapStub.java:886)

In Java we are using only below NTLM registration.

				AuthPolicy.registerAuthScheme(AuthPolicy.NTLM, JCIFS_NTLMScheme.class);

               
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,671 questions
SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,913 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,564 questions
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,441 Reputation points Microsoft Vendor
    2023-02-21T02:41:02.69+00:00

    Hi @BBL

    Have you properly configured authentication for the report server? Please check this link: Configure Windows Authentication on the Report Server.

    Best regards,

    Aniya


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.