Cannon open Data Connector rules with error "Length of the data to decrypt is invalid."
Item import failed
Item Import exception : XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX = Altiris.Connector.DataSource.OleDbDataSource (2ac421a2-33b8-4663-b953-8e8bd0a28393)
Unable to load the specified item: XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX0
Length of the data to decrypt is invalid.
The password hash for the Data Connector source was created on a different server that cannot be decrypted on the server the database is now attached to
set State = replace (cast (State as
--****Hash from Prod goes here****
'PASSWORD HASH FROM ORIGINAL SERVER HERE',
--Hash for server attached to goes here
'PASSWORD HASH CREATED ON THE WORKING SERVER HERE'
where state like
--Hash from prod goes here
'%PASSWORD HASH FROM ORIGINAL SERVER HERE%'