Solved

SQL Server Instance password change

  • 28 November 2017
  • 2 replies
  • 25 views

Badge +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

icon

Best answer by bmorgan 29 November 2017, 20:35

View original

2 replies

Userlevel 5
Badge +18

I believe the Single Sign On will also need to be recached using K2 Workspace:


 


http://help.k2.com/onlinehelp/k2five/userguide/5.0/default.htm#Use/SSOCacheCredentialsFormLoad.htm


http://help.k2.com/onlinehelp/k2five/userguide/5.0/default.htm#K2_Workspace/Settings/Settings.htm#Auto_Login

Badge +4

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.

Reply