Remote procedure call - URGENT

Hello Gurus,
Here I got some strange problem.

I have two servers srv1 and srv2. From query analyzer I am able to run remote procedure call. If I use SQL SERVER JOB
the job is getting failed here is the message
"Login failed for user 'sa'" Reason : Not associated with Trusted connection"

NOTE : I am running NT and SQL option.

Did you create linked server? (Hardcode the userid and password on the security option of linked server)

What authentication mode you use on both servers?

Quote:

---

Originally posted by MAK
Did you create linked server? (Hardcode the userid and password on the security option of linked server)

What authentication mode you use on both servers?

---

I have created Remote server not Linked Server.
Both servers running with SQL and NT mode.
Any idea?

MAP remote logins to different local logins.

Quote:

---

Originally posted by MAK
MAP remote logins to different local logins.

---

no luck..

no the error changed to
"Login failed for domain\username"

Try map to sql login not windows account on remote server.