remoted linked server problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

remoted linked server problem

I am running SQL 2005 trigger and update the table in remote linked server. This is working perfectly when the firewall is off. However when I turn on the firewall, it won¡¯t run any more. I need the firewall on for the security issue. How can I run this trigger with firewall on? Thanks.
Have you checked whether DTC is on and configured properly.
What was the error when firewall is on? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
what firewall are you using.? AKTHAR
Fyi, KBAhttp://support.microsoft.com/kb/306212 too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>