Post reply

Remote link error

  • April 8, 2008 at 11:36 am

    #128478

    I am getting following error when running a stored procedure. when I use my account to run the stored procedure it works fine but one of user trying to run the SP gets following error.

    Cannot fetch the rowset from OLE DB provider "Server1" for linked server "Server2".

    Any help will be appreciated.

  • April 8, 2008 at 3:16 pm

    #800035

    You need to impersonate an id that can allow other user to access link server. You need to set this under Security tab of your linked server properties.

    You can either map an ID or fix ID by typing id and password against "Be made using this security context"

    [font="Verdana"]--www.sqlvillage.com[/size][/font]

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

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