TW Bridge and SA users expired
Revision as of 11:50, 15 June 2012 by David.Burkhead (talk | contribs)
Overview
When you login to System Administrator in TouchWorks EHR v10 or below, CMS Patient Merge or TouchWorks bridge in GE/IDX ConnectR you receive a message indicating that your user's pword will either expire in X days, or has expired.
Soon to expire dialog message:
-2147220384 WARNING: Your pword will expire in 4 days
Expired dialog message:
-2147220383 Your pword has Expired. Please Enter a New pword.
Fix
Run the following SQL in the master database on the clinical DB server:
UPDATE IDX_Login SET PasswordChangedDTTM = getdate() ,ChangePasswordDays = 999 WHERE AUserName = '<insert target username'
This will reset the date when the pword was changed to today, and extend it for 999 days. You could increase the ChangePasswordDays to 32,767, which is the maximum value allowed in that column (data type = smallint).