TW Bridge and SA users expired
Jump to navigation
Jump to search
Overview
When you login to SA (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 password will either expire in X days, or has expired.
The messages that you will see look like the following.
Soon to expire:
Fix
Run the following SQL in the master database on the clinical DB server:
UPDATE IDX_Login SET PasswordChangedDTTM = getdate() ,ChangePasswordDays = 999 WHERE AUserName = 'IDXAdmin'
This will reset the date when the password 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).