Skip to main content
Nintex Community Menu Bar

Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.

  • May 22, 2015
  • 4 replies
  • 97 views

Forum|alt.badge.img+1

 

Hello, I am new to K2 and i just been playing around with smart objects and smart forms. I was able to create a smart form that stores data in a Sharepoint List, however when i try to do the same but on a sql database i get the error below. If i run the SQL smart object created by the SmartObject Tester from the SmartObject Tester it work flawlessly, but when i try it from the smartform i get the error. Any Ideas what is causing this issue.
 
Thanks
 
K2 Smartforms Error------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Login failed for user 'NT AUTHORITYANONYMOUS LOGON'.


•Type: SourceCode.SmartObjects.Client.SmartObjectException

•Source: SourceCode.SmartObjects.Client

•Method Base
◦Member Type: Method

◦Name: ExecuteScalar

◦Module
◾Scope Name: SourceCode.SmartObjects.Client.dll

◦Declaring Type
◾Full Name: SourceCode.SmartObjects.Client.SmartObjectClientServer

•Stack Trace:
at SourceCode.SmartObjects.Client.SmartObjectClientServer.ExecuteScalar(SmartObject smartObject, DataTable inputTable)

at SourceCode.Forms.AppFramework.FormRuntime.SmartObjectExecution(XPathNavigator nav, Boolean outputDependencies, SmartObjectClientServer svr)

at SourceCode.Forms.AppFramework.FormRuntime.WorkXmlToApi(String xml)

at SourceCode.Forms.Runtime.AJAXCall.ProcessRequest(HttpContext context)

4 replies

Forum|alt.badge.img+8
  • Nintex Partner
  • May 24, 2015

Hi Ces

 

What "Authentication Mode" have you selected for your SQL Service Instance?

 

If you have selected Impersonate then check out the following:

 

http://community.k2.com/t5/K2-blackpearl/NT-AUTHORITY-ANONYMOUS-does-not-have-rights-calling-SQL-Server/ta-p/74688

http://help.k2.com/kb001607


Forum|alt.badge.img+1
  • Author
  • May 26, 2015

Thanks Andrew that worked.


Forum|alt.badge.img
  • January 23, 2019

Andrew, I'm having this same problem.  When I try to click the link you provided i am given an access denied message...You do not have sufficient privileges for this resource or its parent to perform this action.

Click your browser's Back button to continue.


Forum|alt.badge.img+1
  • January 23, 2019

Yes  I am getting access denied on that link too! The second link should work though,