-
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?
-
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.
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|