I’ve got issue with stored procedure which takes data from another server (webMethods adapter -> procedure -> data from other server via procedure).
When I try to run adapter with procedure I get an error:
Could not run ‘selectEmployeeDiscount’
com.wm.pkg.art.error.DetailedServiceException: [ART.117.4002] Adapter Runtime (Adapter Service): Unable to invoke adapter service selectEmployeeDiscount.
[ADA.1.316] Cannot execute the SQL statement “?= call *…User_Discounts;1( ?, ?)”. "
(S0001/18456) Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’."
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’.
Rest of procedures works correctly.
In services.msc the Integration server have ‘Logon As’ property set to domain user which have rights to connect to DB.
When I execute procedure (which don’t work on webMethods as I mentioned) in MSSMS with domain user, it works correctly.
Server shows similar info:
Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Could not find a login matching the name provided.
That’s funny cause with MSSMS I get output
Server: Microsoft SQL Server 2014 with Windows log on
I don’t know what more I can do to fix this. Any help?