Post reply

Problem in a sp with distributed queries

  • December 16, 2004 at 9:33 am

    #87247

    Hello everyboy

    I have a sql server called BE2 with a SQL Server 2000 installed with a named instance VSQL4\VSQL4

    I have another server called BE4 with a SQL Server 2000 installed with other named instance called VSQL6\VSQL6

    In a database of VSQL6 I have a proc (PROC_HIST_UKSMS) that do a query against VSQL4, because I need some data, I put the date in #temp tables. Later, in this proc, a begin a transaction to modify data in my database on VSQL6.

    I have VSQL4 as linked server in vSQL6

    When I execute my proc I get the next error:

    Server: Msg 8501, Level 16, State 3, Procedure PROC_HIST_UKSMS, Line 17

    MSDTC on server 'VSQL6\VSQL6' is unavailable.

    But If I execute each query alone all the things work.

    Do anybody have an idea of what is the problem?

    Thanks in advance!!!

     

     

  • December 16, 2004 at 10:01 am

    #534180

    Is MSDTC running on VSQL6???



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • December 16, 2004 at 10:06 am

    #534182

    Yes, MSDTC is running

     I forgot to say that VSQL6 is on cluster....

     

  • December 20, 2004 at 10:07 am

    #534497

    It can be firewall or permissions issue (DTC startup account). There is an excellent utility for DTC trubleshooting: http://download.microsoft.com/download/e/a/2/ea20a97f-672d-4826-8e52-1e83e7d9ddfb/dtcping.exe

    And here is an article for DTC on cluster server (but try DTCping first): http://support.microsoft.com/?id=294209

  • December 24, 2004 at 8:38 am

    #534982

    what do you have as the data source ? Can you post the output of sp_linkedserver 'lnkservername'

Viewing 5 posts - 1 through 4 (of 4 total)

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