Difference between revisions of "TW Bridge and SA users expired"
Jump to navigation
Jump to search
(New page: == Overview == When you login to SA (System Administrator) in TouchWorks EHR v10 or below, or TouchWorks bridge in GE/IDX ConnectR you receive a message indicating that your user's passwor...) |
(No difference)
|
Revision as of 20:02, 2 June 2008
Overview
When you login to SA (System Administrator) in TouchWorks EHR v10 or below, 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.
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).