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