Proble with distributed transaction

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Proble with distributed transaction

Author

Topic

shafik01
Starting Member

1 Post

Posted - 2009-07-13 : 06:37:50

Dear all,
hai i m trying to execute query in remote server from my local server
when i select or update query from web server it work fine
but when i exectue insert statement from Stored procedure in Web server.
it give followign error.

The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "75.125.162.34,8327" was unable to begin a distributed transaction.
OLE DB provider "SQLNCLI" for linked server
"75.125.162.34,8327" returned message
"The transaction manager has disabled its support for remote/network transactions.".

i have set the msdtc setting already
and msdtc service is enable in my both client pc as well as server pc

if any body know wht the setting require in remote pc
plz let me know

d

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-13 : 06:47:04

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. The service will restart
8. BUT YOU MAY NEED TO REBOOT YOUR SERVER IF IT STILL DOES NoT WORK

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.

-------------------------
R..

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources