X hits on this document

396 views

0 shares

1 downloads

0 comments

38 / 131

1.

2.

The user defined in the Topology to connect to the Microsoft SQL Server instances must have the following privileges:

It must be the 'db_owner' of the staging area databases It must have 'db_ddladmin' role For automatic link server creation, it must have 'sysdamin' privileges

The MSDTC Service must be started on both SQL Server instances (source and target). The following hints may help you configure this service:

the 'Log On As' account for the MSDTC Service is a Network Service account (and not the 'LocalSystem' account)

MSDTC should be enabled for network transactions

Windows Firewall should be configured to allow the MSDTC service on the network. By default, the Windows Firewall blocks the MSDTC program.

The Microsoft SQL Server must be started after MSDTC has completed its startup

The links below can help you further configure you MSDTC Service: http://support.microsoft.com/?kbid=816701 and http://support.microsoft.com/?kbid=839279

Knowledge Modules Reference Guide

38/131

Document info
Document views396
Page views399
Page last viewedThu Dec 08 04:59:26 UTC 2016
Pages131
Paragraphs3942
Words42855

Comments