SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Getting login failed error when trying to run sql agent jobs after failback or failover


Getting login failed error when trying to run sql agent jobs after failback or failover

Author
Message
sasken
sasken
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3668 Visits: 1948
Hello All,

I am using SQL Server 2008 R2 SE. For HA I am using double take. The source and target servers are both on Windows Server 2008 R2 Standard. I using a single domain account to run the sql server and sql server agent services on both source and target servers and at any given point of time I have either the source or target up and running. The failover and failback works fine without any issue fulfilling our needs. But I am having an issue with the sql agent jobs after performing a failover or a failback. None of the sql agent jobs run. They fail with the following error:

'Login failed for user 'username'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)'

However when I break the double take mirror and run the jobs on individual servers using the same account they run fine with out any issue. I have contacted double take and they said this is a bug from Microsoft which I am not sure of. Can someone kindly help me fix this issue.

Please let me know if you need additional details. Thanks a ton in advance.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
sasken
sasken
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3668 Visits: 1948
Experts I need your valuable inputs. Thanks Again.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
sasken
sasken
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3668 Visits: 1948
I verified my local policy settings and found out that "Enable computer and user accounts to be trusted for delegation" has none added to this policy. I just added the SQL Server Service Account and the Administrators group to it. I will keep posted if it works fine.

Still waiting for the experts thoughts/inputs.

Thanks

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
sasken
sasken
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3668 Visits: 1948
Sapen (9/26/2012)
I verified my local policy settings and found out that "Enable computer and user accounts to be trusted for delegation" has none added to this policy. I just added the SQL Server Service Account and the Administrators group to it. I will keep posted if it works fine.


Thanks


That is the fix. Adding the sql server service account to the "Enable computer and user accounts to be trusted for delegation" policy and sql services restart fixed the issue.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search