Post reply

Linked servers problems

  • March 30, 2005 at 5:49 am

    #68810

    Hello

    We have 2 SQL Servers one with NT 4 Enterprise SP6 called SVNT and the other with Windows 2K SP4 called SV2k.

    Sometimes (some days) we have errors when we call stored procedures that have distributed queries or calls to stored procedures from SVNT to SV2K.

    No error messages appear but the client application that calls the Stored doesn't work. The client connects SVNT with ODBC (Sql Sever driver 200.85.1022.00). The session generated by stored procedure on SV2k is active until the SV2K is shutdown and we are not allowed to do kills, this message appears when we try to kill the session:

    SIPD : a transaction is being rollback. Estimated operation completed: 100% (in

    original spanish: SPID : se esta deshaciendo una transaccion. Estimacion de operacion

    completada: 100%. Tiempo restante estimado: 0 segundos.)

    If we call the stored procedure from query analizer from the same client, it works.

    Can anybody help me please?

    We suspect that this happens when SV2k is rebooted after SVNT

    Thanks

     

  • April 1, 2005 at 8:32 am

    #550116

    I have used Linked servers quite a bit.  If you are calling a stored procedure via linked serverrs you need to make sure RPC is enabled.  I am by no means an RPC expert but from my IT days I know there are differences between RPC and security on NT4 and W2K.  I am guessing that may be the issue.  I am not sure if this helps much but sometimes even getting a little direction can help.

     

    Bruce Szabo


    Bruce Szabo, MCSE+I, MCDBA, MCSD

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

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