Skip to main content
Nintex Community Menu Bar
Solved

SQL Server Instance password change

  • November 27, 2017
  • 2 replies
  • 66 views

Forum|alt.badge.img+4

Hi,

 

I have created a smart object whose data is supplied by a SQL Server Service Instance.

 

The SQL Server Service Instance authenticates by SSO.

 

Things were working well until the user account that the service instance was using to authenticate had a password change.

 

In K2 Manager, I updated the password in the service instance configuration to the new password (and a confirmation appears indicating successful connection).

 

However, back in K2 designer and runtime, if I try to launch anything that uses this particular service instance, I get an error: Logon failure: unknown user name or bad password.

 

I have searched around for an answer, a couple of articles suggest caching is the issue, but the suggested solutions are for a much older version of K2, ("K2 Workplace", what is that? we are using K2 Five) and the instructions just don't sync with what I see.

 

Does anyone have any suggestions?

 

Thanks

Best answer by bmorgan

Thank you,

 

Going into the workspace, removing then re-adding credentials; then also, going into the service instance and again updating the password finally fixed this issue.

2 replies

Forum|alt.badge.img+18
  • November 29, 2017

Forum|alt.badge.img+4
  • Author
  • Rookie
  • Answer
  • November 29, 2017

Thank you,

 

Going into the workspace, removing then re-adding credentials; then also, going into the service instance and again updating the password finally fixed this issue.