TW Bridge and SA users expired

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).