January 5, 2009 at 8:08 am
I have been having an issue with distrubuted transactions between 2 sql servers. I create a temp table, load the data to the other server, and then update the rows on the host server comparing the temp table rows to the actual table. it runs fine as long as I don't make it a distrubuted transactions. I have
SET XACT_ABORT ON
begin distributed tran
at the beginning. I get the error message below
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "cmsphsql" was unable to begin a distributed transaction.
What settings could I have wrong that may cause this?
January 5, 2009 at 8:21 am
Hi Tim,
Have you checked:
http://support.microsoft.com/kb/306212/en-us
The only time I have had to deal with this it was a name resolution issue.
Let us know if this helps.
January 5, 2009 at 10:18 am
I would also check that DTC is enabled for network access and you allow transaction manage communication.
January 5, 2009 at 10:31 pm
timscronin (1/5/2009)
I have been having an issue with distrubuted transactions between 2 sql servers. I create a temp table, load the data to the other server, and then update the rows on the host server comparing the temp table rows to the actual table. it runs fine as long as I don't make it a distrubuted transactions. I haveSET XACT_ABORT ON
begin distributed tran
at the beginning. I get the error message below
Msg 7391, Level 16, State 2, Line 3
The operation could not be performed because OLE DB provider "SQLNCLI" for linked server "cmsphsql" was unable to begin a distributed transaction.
What settings could I have wrong that may cause this?
--DTC should be anable
--Remote access ,remote admin connections should be enable
--Create link server of remote server database
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply