Why job is failed when it is Scheduled ?

[sarah77]

I created a job on server-2 to import a database from server-1.

When I run the job immidately it works but when I make a shedule for the job it fails, WHY ?


( Both servers are sql2000 running under win2000 server )

Thanks for any comment

 

[cmmrfrds]

Do you have SQL Agent running and what is the error message you are receiving?

 

[cinjion]

Sounds like when you run it as yourself, you have appropriate permissions on Server1, but the account SQL Agent runs on may not have appropriate permissions on Server1. Agent must be a domain user account also...

 

[sarah77]

infact, sql server agent is not running on server-1.
But I think it should works while the job is running on server-2 and its sql agent is running .

I logged in into both servers with "administrator" account as domain logging in.


I appriciated your help

 

[tlbroadbent]

When you run the job, it runs under the SQL Agent login account, not the Windows login (Administrator). That account must have login permissions on the remote SQL Server. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[sarah77]

Thanks, it was really a matter of permission.

I found in propreties of "sql server agent" of server2 that the user "domain/administrator" who is starting the sql agent.

By asking the netwokrk administartor he said that he changed the password of "domain\administrator" on the domain controler server win2000 so the old password was not changed for sql server agent of server2.

After I changed the passowrd to be match each other I was be able to start the sql server agent of server2.

Thanks for help for all of you.