SQL Server Performance Forum – Threads Archive

Error in copying data from Oracle to sql server

Any 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 —
http://www.sqlserver2005.de
—

---

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
http://www.SQL-Server-Performance.Com
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!

---

]]>