Home Forums SQL Server 2008 SQL Server 2008 - General Linked server permissions issue RE: Linked server permissions issue

  • November 30, 2011 at 10:11 am

    #1414820

    Sapen (11/30/2011)

    Forgot the Mention that I am using SQL Server 2005 Standard Edition. I have enabled the RPC but still ended up getting the same error. I dont see the distributed transaction at the server options but I do see it at the sqlserver properties unchecked "Requires distributed transaction for server-to-server communication".

    I just enabled it and ran my queries and ended up with same error again.

    Hmm... What credentials are you passing to the linked server? Are you impersonating? Sending explicit creds?

    Jared

    Jared
    CE - Microsoft