tracing SA login Falied

• devereauxj

  Hall of Fame

  Points: 3263

  More actions

  November 23, 2004 at 6:24 am

  #84268

   

  I have a new client that has a SQL Server database. 1 server 14 users.  They are getting SA Denied.  I have put a trace on it and something is trying to kick off "0sql" with password SA.  I am having trouble finding out where it is coming from.  The server is one location and the "clients" are in 7 different locations.  I can't get them to shut everything down and bring it up one by one.  I have used Ethereal to trace the ports, but it was my first time using it, and still trying to figure out what the data means.

  Any one have ideas on how to trace the SA login back to find out what process is kicking it off?

   

  Thanks,

  Joseph

• November 26, 2004 at 8:00 am

  This was removed by the editor as SPAM

• mishrat

  Newbie

  Points: 8

  More actions

  November 29, 2004 at 7:19 am

  #531715

  Have you or anybody changed SA login..

  DTS stores Login/PW information with it.

  You may try updating the "Run with" information again.

  DTS also stores Log directory info.

  New server's NT user should have read write access  to the log directory.

  Best Luck

  ---

  Keep Smiling,

  mishrat