Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Upgrade to SQL 2012 linked server issue

After upgrading from SQL 2008 to SQL 2012, I'm am getting some jobs failing with an "SALESFORCE". [SQLSTATE 42000] (Error 7320) OLE DB provider "DBAmp.DBAmp" for linked server "SALESFORCE" returned message "Error 1 : INVALID_OPERATION_WITH_EXPIRED_PASSWORD: The users password has expired, you must call SetPassword before attempting any other API operations". [SQLSTATE 01000] (Error 7412). The step failed.
1 person has
this question