/**********************************************************************************************
-- Title : [2k5] 네트워크 (분산) 트랜잭션 허용
-- Reference : http://support.microsoft.com/kb/873160/ko
-- Key word : 파트너 트랜잭션, 분산 트랜잭션 distributed transaction MSDTC MS DTC
**********************************************************************************************/
네트워크 분산 트랜잭션 허용.docx
-- Error Message
연결된 서버 "LINKED_YUGWANSUN"의 OLE DB 공급자 "SQLNCLI"이(가) 메시지 "파트너 트랜잭션 관리자가 원격/네트워크 트랜잭션에 대한 지원을 할 수 없습니다."을(를) 반환했습니다.
메시지 7391, 수준 16, 상태 2, 줄 1
연결된 서버 "LINKED_YUGWANSUN"의 OLE DB 공급자 "SQLNCLI"이(가) 분산 트랜잭션을 시작할 수 없으므로 요청한 작업을 수행할 수 없습니다.
First verify the "Distribute Transaction Coordinator" Service is
running on both database server computer and client computers
1. Go to "Administrative Tools > Services"
2. Turn on the "Distribute Transaction Coordinator" Service if it is not running
If it is running and client application is not on the same computer as
the database server, on the computer running database server
1. Go to "Administrative Tools > Component Services"
2. On the left navigation tree, go to "Component Services > Computers
> My Computer" (you may need to double click and wait as some nodes
need time to expand)
3. Right click on "My Computer", select "Properties"
4. Select "MSDTC" tab
5. Click "Security Configuration"
6. Make sure you check "Network DTC Access", "Allow Remote Client",
"Allow Inbound/Outbound", "Enable TIP" (Some option may not be
necessary, have a try to get your configuration)
7. Check another "Not Need Authentication"
8. The service will restart
9. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOESN'T WORK
(This is the thing drove me crazy before)
On your client computer use the same above procedure to open the
"Security Configuration" setting, make sure you check "Network DTC
Access", "Allow Inbound/Outbound" option, restart service and computer
if necessary.
On you SQL server service manager, click "Service" dropdown, select
"Distribute Transaction Coordinator", it should be also running on
your server computer.
* 추가 참조 자료 : http://www.simpleisbest.net/archive/2005/07/04/173.aspx
