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
To resolve the issue you must get the password hash from the original server and the password hash for the same password from the destination server. To do this right click on a Data Connector Data source item in the tree that has had the password entered and locate the Password hash.
Enter the hash from each server in the location indicated in the query below and run this against the copy of the production database. Make sure not to run it against the production database.
set State = replace (cast (State as nvarchar (max)),
--****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 Guid in
where state like
--Hash from prod goes here
'%PASSWORD HASH FROM ORIGINAL SERVER HERE%'
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe