Tuesday, October 12, 2010

SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred

Code: 0xC0202009
Source: Connection manager ""
Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Cannot generate SSPI context".

I got this error recently, and could find almost no useful posts about what caused it and how to solve it, so here's what I found. It's simple!
When the "domain guy" in our company setup the domain account that SQL Server Agent runs under up, he didn't check "password never expires", so the account's password had expired, causing all the Integration Services packages that connect to Windows Authentication connections to fail. I modified the account in Active Directory Users and Computers to never expire, reran the packages, and they succeeded.
So, to summarize, make sure the account you're using for SQL Server Agent is in a good state as your first level of troubleshooting!

If this helps you out, leave a comment to help encourage me to post more often!



Sami said...
This comment has been removed by the author.
Sami said...

Thanks Rick. Now go find some more error fixes. ;)