Tuesday, 6 January 2015

ACCESS TO THE REMOTE SERVER IS DENIED BECAUSE THE CURRENT SECURITY CONTEXT IS NOT TRUSTED

I had a scenario in which there was a configuration error in a Linked Server. There was an error populating when tried to access few SSRS reports.

Error was as per the below screen shot -


The above error was coming due to the access/mapping problem of the system/administrator account with Linked server, To resolve this problem, it is required to map the system/administrator account with the particular linked server.

Right click to the linked server and select Properties :



Under security tab, change the radio button selection from Be made without using a security context to Be made using this security context, and enter your system/administrator account and password.


After successful configuration, click on OK button. it will resolve the problem.

Please mark as comment if it solved your problem.