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.