SQL Server Performance

Error in copying data from Oracle to sql server

Discussion in 'SQL Server DTS-Related Questions' started by I_Have_A_Doubt, Jan 25, 2007.

  1. I_Have_A_Doubt New Member

    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!!
  2. jsuessmeyer New Member

    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
    ---
  3. satya Moderator

    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.
  4. I_Have_A_Doubt New Member

    Thank you Guys!!!

    This was of great help!

Share This Page