I have a problem where I am trying to isntall emc's documentum e-room.
I have already posted on their forum with no help.

I have two 2003 servers. One has sql server 2000 sp4 and the other one
is configured as the sql client.

When I run the eroom wizard for a new site on the client, I enter the
information for the username I created on the sql server and when I
get to the final step I get an error.

Please note that both "Network COM+" and "Network DTC Access" are
installed and enabled.

The error I am getting is:


11/23/2007 09:59:38 ERCreateSiteWizard[664:ad0]: Storage,0: ERROR:
PersistODBC on DRIVER={SQL
Server};SERVER=SQL;Trusted_Connection=no;UID=eroom ;;DATABASE=eRoom_eRoomSite
11/23/2007 09:59:38 ERCreateSiteWizard[664:ad0]: ODBC,0: (25S12)
[Microsoft][ODBC SQL Server Driver]Distributed transaction error
[-2147168220]
11/23/2007 09:59:38 ERCreateSiteWizard[664:ad0]: Storage,0: unexpected
exception caught in CERPersist::StartTransaction(). Couldn't start
transaction.
11/23/2007 09:59:38 ERCreateSiteWizard[664:ad0]: Admin,0:
CERCreateSitePropSheet::OnCreateSite - Failed to create site snt on
database server: SQL HRESULT: -2147217409

Not sure what other information you guys will need but I will be
watching this thread closely so if any more info is required I will
post asap.