Post reply

SQL Account access to multiple servers

  • May 4, 2009 at 10:06 am

    #129760

    I have a SQL Server A where in it has sql account used for an application. When i try to run a query in a store proc like

    " SELECT name FROM RevProd.master.sys.databases WHERE name = RevBud"

    I get the following error

    Access to the remote server is denied because the current security context is not trusted.

    though i use execute as user "sysadmin account" with in the procedure.

    SO.. How does a sql account access multiple servers?

  • May 4, 2009 at 11:06 am

    #988213

    in this case I believe you'd have to setup a linked server and the proper local to remote login mappings.

  • May 4, 2009 at 3:38 pm

    #988437

    RevProd.master.sys.databases

    What access have u got to this server?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply