Question

Caladiya on Mon, 07 Dec 2015 05:30:43


I need to know Distributed transaction from different server located in different geographical place .

How can I connect with them ?


Sponsored



Replies

Ahsan Kabir on Mon, 07 Dec 2015 05:37:07


You have to establish linked server between your server by that you will get trusted relation between them .

Linked servers establishing a connection in SQL Server to a compatible remote OLE DB provider. It stabilizing connections to other types of servers, such as DB2 including Microsoft Access and Excel. Typically, linked servers are used to handle distributed queries.


Ahsan Kabir Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread. http://www.aktechforum.blogspot.com/


Ahsan Kabir on Mon, 07 Dec 2015 05:39:32


To establish link server see below article of mine :

Making Linked Server in SQL Server 2014

Visakh16 on Mon, 07 Dec 2015 05:57:38


There are few configuration settings you need to do to enable distributed transaction through linked server

see

http://blogs.msdn.com/b/sqlforum/archive/2010/12/20/faq-how-do-i-configure-sql-server-to-enable-distributed-transactions-via-linked-server.aspx