May 8, 2008 at 4:16 am
So I have this server1, which needs to talk with server2. Standard every server runs under Local System account, as does each SQLServerAgent. Server2 is isolated from everything except specified servers with a firewall. Server1 has been granted access to server2: when I login on server1, open Management Studio I can connect to server2, noproblem. My Login has GlobalAdmin rights.
Now I let the SQLServerAgent run under my Login, which has GlobalAdmin rights. I start a job which connects to server2, the job imports a table from server2 to server1. The job fails with:
(snip)
Description: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection."
I don't understand this. Since the job runs under an account with global admin rights, I would think the job would have access to server2. Why does this not seem to be the case?
Oh, on server1 the SQLServer service also runs under this account; server2 runs with Local System.
Help?
Greetz,
Hans Brouwer
May 8, 2008 at 6:30 am
Check the owner of the job.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply