Subversion Repositories Aluchemie.datataker

These are the steps followed by me.

1. Created Linked Server with the Server Type as ‘SQL Server’

A. provided the following in the security tab

i. Local Login
ii. Remote login
iii. Remote Password
iv. Selected Be made using this security context option and
provided Remote Login & Remote Password

B. Provided the following in the server options

i. Checked data access
ii. Checked RPC In
iii. Checked RPC Out

2. Checked “Enforce Distributed Transaction” in the source server
under Server Properties -> Connections

3. Started Distributed Transaction Coordinator is both the servers
Enabled Network DTC Access under Control Panel -> Adminstrative
Tools -> Component Services -> Computers -> My Computer. Right
click My Computer and go to properties, Go to MSDTC. Click on
Security configuration. Check Network DTC Access, Allow Inbound
and Allow Outbound in both the source and target and restarted
both the server (I mean the server and not sql server)

4. Then executed the query. Before I executed the query, I did SET
XACT_ABORT ON