Post reply

Could not execute procedure 'sp_GetValue' on remote server 'SBI-SERVER-ALIAS'.

  • April 6, 2009 at 3:17 am

    #130387

    HI,

    I am trying to executing sp on customer server using this syntax

    Exec [ServerName].database.dbo.sp_Getvalue then

    I got error.

    Could not execute procedure 'sp_GetValue' on remote server 'SBI-SERVER-ALIAS'.

    Please provide me solution for that.

    SERVER-ALIAS is my linked server name

  • April 6, 2009 at 3:28 am

    #972371

    Does the login you are executing the statement as have rights to execute that sp on the remote server?

    have you tried going on to the other server and executing it (if it is safe to do that of course)

    Hope this helps,
    Rich

    [p]
    [/p]

  • April 6, 2009 at 11:46 pm

    #973111

    yes, I have tried it on other server and found that it works fine

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

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