We have a Biztalk Server working with SQL Server 2000 at backend. The Biztalk created Backup Job for Full backups and Tran Log backups suddenly started failing with error as below. It uses service Account. Any help with MSDASQL will be appretiated.
OLE DB provider 'MSDASQL' reported an error. Authentication failed.
[SQLSTATE 42000] (Error 7399)
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
[SQLSTATE 01000] (Error 7312)
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.].
[SQLSTATE 01000] (Error 7300)
The step failed.
Authentication problem are never fun...