Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
darmin
Starting Member
2 Posts |
 Posted - 2007-11-23 : 03:48:39
|
| 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 installation 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_eRoomSite11/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: -2147217409Not 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. |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-23 : 04:58:02
|
| The account you are using for COM+, is it a member of the Network Configuration Operators?Can you ping the server from the client with the name (not IP Address) and vice-versa? Has to be the name as DTC uses name resolution. |
 |
|
|
darmin
Starting Member
2 Posts |
Posted - 2007-11-23 : 07:51:27
|
| Since we have a domain, I made the account part of both local & domain network configuration operators.As far as the ping goes, yes they can ping. They can ping both ways. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-24 : 01:14:06
|
| Is msdtc running on both machines? |
|
|
|
|
|
|
Client won't write on sql server