Facing the same problem

I am facing the same (well, similar) issue as the OP. Here's the
scenario. My stored procedure is being activated from a Service Broker
queue. Within the stored procedure, it is trying to do some operations
across a Linked server, which is failing with the 15274 (Access to the
remote server is denied because the current security context is not
trusted.) error.

The linked server is a SQL server, but not one where I have any
control. The username & password for connecting to the linked server
were provided to us by another team, so we have to use that only.

What is the solution to this problem (does a solution even exist??!)

Needless to say, the procedure works when executed from an interactive
session.

Regards,
Andy
.

Relevant Pages

  • Re: User-Defined Function
    ... It doesn't even have to be this elaborate with a linked server. ... Declare @line varchar ... suitable extended stored procedure. ... > server setup and an example of how to get directory information (but not ...
    (microsoft.public.sqlserver.programming)
  • RE: Stored Procedure to Connect a DBF File
    ... but you might be able to create a Linked Server to the ... after setting up an ODBC connection to it. ... > of DBF file using / with in the Stored Procedure? ...
    (microsoft.public.sqlserver.server)
  • RE: Stored Procedure to Connect a DBF File
    ... but you might be able to create a Linked Server to the ... after setting up an ODBC connection to it. ... > of DBF file using / with in the Stored Procedure? ...
    (microsoft.public.sqlserver.programming)
  • ANSI_WARNINGS error in Stored Procedure
    ... I have a linked Server on my regular SQL server, and when I try to create a stored procedure that reads from the linked server, I get the following error: ... THIS ENSURES CONSISTENT QUERIES SEMANTICS. ... The query that is to be performed in the stored procedure is a simple SELECT, ...
    (microsoft.public.sqlserver.security)
  • xp_logevent and service broker queues
    ... CREATE QUEUE AsyncTargetQueue WITH STATUS = ON, RETENTION = OFF, ... The dbo has a login name who is member of the sysadmin role. ... Maybe somebody can give me a hint how to call 'sysadmin' functions under the dbo user or how to change permissions for calling these functions in a stored procedure which is started by a service broker queue. ...
    (microsoft.public.sqlserver.security)
Loading