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 |
|
phani1312
Starting Member
1 Post |
 Posted - 2007-09-20 : 04:50:24
|
| Hi We are facing some problem when we try to execute remote access from SQL 2005 cluster to another SQL 2005 server(Not clusterd)Got the following error row(s) affected)OLE DB provider "SQLNCLI" for linked server "172.21.20.198" returned message "The transaction manager has disabled its support for remote/network transactions.".Msg 7391, Level 16, State 2, Procedure sp_BG_DB_BKP, Line 14The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "172.21.20.198" was unable to begin a distributed transaction.We found one article to enable DTC on Cluster serverHow to enable network DTC access in Windows Server 2003http://support.microsoft.com/kb/817064/Pelase advice, can we procceed with installing MSDTC on cluster server, will there be any impact?TQPhani |
|
|
|
|
|
network DTC access in Windows Server 2003