Stored procedure problem

• Jo Picard

  Newbie

  Points: 5

  More actions

  May 17, 2006 at 2:53 pm

  #169516

  Hi,

  I work with a third party application. This application give a stored procedure available for programmer.

  In this stored procedure I want to insert data in a database on an other sql server.

  So, I add a link between this 2 server with the sp_addlinkedserver stored procedure and the sp_addremotelogin. Both server will has the same login and password.

  If I call the stored procedure manually using query analyzer (with both, windows authentification and sql authentification) everything works fine, but if the stored procedure is called by the application, the stored procedure doesn't work.

  Any idea of want can be wrong or suggestion, comments ??

  Thank you for your help

  Jo

• danschl

  SSCertifiable

  Points: 5770

  More actions

  May 17, 2006 at 3:02 pm

  #638564

  more than likely  a rights issue

  you could turn on the profiler on the remote sql server

  looking in the security audit for failed logins

  and/or look at the rights on the local server too