I have a front end that logs into the DB as "logInA", and only has permission to "schemaA" stored procs, which use EXECUTE AS "logInB", (I have also tried EXECUTE AS 'DBO'), to handle all the business logic.
I have run into a problem though, where a query tries to access a table on a Linked Server, and returns the error:
Access to the remote server is denied because the current security context is not trusted.
If it helps, the source server is SQL 2008, and the linked server is SQL 2005.
Can any one help me as to how to resolve this?
Thanks in advance