Getting Login Failed for user 'NT AUTHORITYANONYMOUS LOGON' on LIST Method

  • 9 August 2013
  • 5 replies
  • 11 views
R
Badge

I have K2 BlackPearl installed on one server, the database on a second server, and have created a ServiceInstance/SmartObject pointing to a SQL database on a third server.


The Create, Read, Update and Delete methods all work fine.  However, on the list method, I get a "Login failed for user 'NT AuthorityANONYMOUS LOGON'.


Service Instance Settings:



  • Authentication Mode = Service Account
  • UseNative SQL Execution = true
  • On Different SQL Server = true (if I set this to false I get a different error on all methods)
  • Use parameters for stored procedures = true

Using BlackPearl 4.6.6


I'm using the SmartObject Services Tester to get these results.


 

5 replies

S
Badge +6

Does the K2 service account have right permissions on the third server. Try making it a sysadmin and see if the error changes. When the error is shown, check the application and security event logs on the third SQL server for more information.

H
Badge +1

When database is residing on another server (Non K2 database Server), in that case.

set Use Native SQL Execution = false

M
Badge +10

Some good information on the issue that causes this.  Configuring Kerberos will allow for native execution to be used in this scenario.


 


https://sqlbadboy.wordpress.com/2013/10/11/the-kerberos-double-hop-problem/


http://blogs.technet.com/b/askds/archive/2008/06/13/understanding-kerberos-double-hop.aspx

W
Badge +6

We recently had a case where we needed to move our K2 database to a different SQL server.  After the move, I could connect to any remote SQL servers that were previously set up, except for one SQL database that had previously been on the same SQL server as K2.  The error was throwing Anonymous just as the OP.  The service instance was configured to use native SQL execution, and when I turned that off, it cleared up.

 

What I don't understand is how the rest of my SQL server instances that are set to "Use Native SQL Execution = True" are working with no issues?  They are all on different database servers than where the K2 database now resides.  We're not using kerberos.. ClientWindows instead.

Z
Badge +9

Are they all configured in the exact same way? The following describes what happens when "Use Native SQL Execution" and "On Different SQL Server" is set to true: https://help.k2.com/onlinehelp/k2blackpearl/userguide/current/webframe.html#Option_1.html

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings