Difference between revisions of "TW Bridge and SA users expired"

From Galen Healthcare Solutions - Allscripts TouchWorks EHR Wiki
Jump to navigation Jump to search
Line 1: Line 1:
 
== Overview ==
 
== 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.<BR><BR>
+
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.<BR><BR>
  
 
The messages that you will see look like the following.<BR><BR>
 
The messages that you will see look like the following.<BR><BR>
 
Soon to expire:<BR>
 
Soon to expire:<BR>
[[Image:IDXAdmin_password_is_expired.jpg]]<BR><BR>
+
[[Image:IDXAdmin_password_will_expire.jpg]]<BR><BR>
  
 
Expired:<BR>
 
Expired:<BR>
[[Image:IDXAdmin_password_will_expire.jpg]]<BR><BR>
+
[[Image:IDXAdmin_password_is_expired.jpg]]<BR><BR>
  
 
== Fix ==
 
== Fix ==

Revision as of 18:16, 17 July 2008

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:
IDXAdmin password will expire.jpg

Expired:
IDXAdmin password is expired.jpg

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