question

mqaiser avatar image
mqaiser asked

SQL AGENT JOB Authentication Error for Cross Domain Database

Hi Everyone, Can someone advice/help on my problem below? I have two SQL server instances running in different machines across different domain. I have created synonyms to access cross server databases. But when I am going to schedule agent job, I got error as: Executed as user: VitalDataSupp. Access to the remote server is denied because the current security context is not trusted. [SQLSTATE 42000] (Error 15274). The step failed. Thanks Qaiser Melbourne
agent
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM avatar image JohnM commented ·
What is the job doing? I'm assuming that the service account doesn't have access to the secondary domain thus causing the issue. Are the two domains trusted?
0 Likes 0 ·

1 Answer

·
mqaiser avatar image
mqaiser answered
Hi John, Two domains are not trusted and separate to each other on two different hosting companies. We can access the cross domain databases through SSMS and have already created linked servers. I have now done two things, 1. I have changed service username for sql server instance and agent service with sql_service which has full permissions. 2. I have also updated Linked Server with proper source username and password and access the data through agent job, it worked. It seems all working. Thanks Qaiser
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.