Remote procedure call - URGENT

[srinisqldba]

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.

[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?

[srinisqldba]

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?

[MAK]

MAP remote logins to different local logins.

[srinisqldba]

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

no luck..

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

[rmiao]

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