SQL Server Performance Forum – Threads Archive
Error in copying data from Oracle to sql serverAny solution for this error : [Microsoft][ODBC driver for Oracle][Oracle]ORA-28000: the account is locked Error source: Microsoft OLE DB Provider for ODBC Drivers This is getting raised in a job which runs daily and pulls data from oracle server and copies into sql server 2000 database.
Plz help… its urgent!!
that is probably because someoe changed the password / or somebody wanted to tamper the password and the account was locked. Unlock the account on the Oracle side and you are fine.
HTH, Jens K. Suessmeyer.
Microsoft SQL Server MVP —
Also check on Windows about login status, that is SQLAgent account as you are trying to schedule this as a job. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
Thank you Guys!!! This was of great help!