sql error

• harikolluri

  SSC Veteran

  Points: 233

  More actions

  January 5, 2006 at 10:10 am

  #96256

  I have three instances of sql server 2000 on three boxes.

  WE collect the data on box1 and box2 and copy that data onto box3. We have couple of stored procedures whhich copy the data from box2 and box1 onto box3. It was working fine for the last few monts. But from last 4 hours the job is failed and its giving the following message

   Executed as user: abcd\servicestart. SQL Server does not exist or access denied.

   [SQLSTATE 42000] (Error 17).  The step failed.

  But the sqlserver exists on all the 3 boxes and they are connected and even we haven't changed any login info on all the 3 boxes. What could be the reason for the above error.

   

  Thanks.

• SQLBill

  SSC Guru

  Points: 51440

  More actions

  January 5, 2006 at 12:00 pm

  #612998

  It could be lots of things....have you checked the SQL Server Error log for messages, how about the Windows Event Viewer logs on each box?

  Also, right click on that job, select View Job History..., then check the box for "Show step details". Check the step that failed.

  -SQLBill