SQL 2005 MSDTC

Discussion in 'Installation & Compatibility' started by rmps, Jan 19, 2007.

  1. rmps

    rmps

    Joined:
    Jan 19, 2007
    Messages:
    1
    Likes Received:
    0
    After numerous growing pains of getting Vista upgraded from XP Pro SP2, I've finally arrived at the last hurdle. Installing SQL 2005 Server (this is a development machine). I have installed SQL 2005 Server, plus CTP SP2, and, whenever I start an SQL script that uses linked servers, I get MSDTC on 'XXXXXX' is unavailable. And yet, MSDTC is running, I've applied all of the new security stuff for MSDTC to allow network connections. But no joy. Anyone with any problems regarding this? Anyone happily running SQL 2005 Server (Standard) on Vista? BTW, the serverthat SQL says is unavailable is the machine I'm runningon! Love being on the bleeding edge... :D

    Here's the actual message:

    Dropping foreign keys from [dbo].[D_CALL_LOG]
    Dropping constraints from [dbo].[D_CALL_LOG]
    Dropping index [IX_D_CALL_LOG] from [dbo].[D_CALL_LOG]
    Rebuilding [dbo].[D_CALL_LOG]
    Msg 15477, Level 0, State 1, Server RMPSWS, Procedure sp_rename, Line 465
    Caution: Changing any part of an object name could break scripts and stored
    procedures.
    Creating index [IX_D_CALL_LOG] on [dbo].[D_CALL_LOG]
    Creating primary key [PK_D_CALL_LOG] on [dbo].[D_CALL_LOG]
    Adding foreign keys to [dbo].[D_CALL_LOG]
    Creating [dbo].[D_LOC_INST_LIST]
    Msg 8501, Level 16, State 3, Server RMPSWS, Line 11
    MSDTC on server 'RMPSWS' is unavailable.
     
    rmps, Jan 19, 2007
    #1
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.