ISA Between SQLs

  • From: "Alex Decarli" <adecarli@xxxxxxxxxxxxxxxxx>
  • To: <isalist@xxxxxxxxxxxxx>
  • Date: Mon, 13 Sep 2004 14:28:54 -0300




Hi Mrs,


I´m trying to make a Transaction with 2 SQL Servers between ISA Server
The scenario is:

 _____                ______                 ______
|       |   TCP 1433->   |      |   TCP 1433->  |      |
|     |   <-TCP 1433   |      |   <-TCP 1433  |      |
| SQL   |________________| ISA  |_______________| SQL  |
| WAN   |   RPC 135 ->   |      |   RPC 135 ->  | LAN  |
|_____|   <-RPC 135    |______|   <-RPC 135   |______|



ISA RULES: Server Publish: SQL LAN - TCP: 1433
           Server Publish: SQL LAN - Any RPC
           Protocol Rules: SQL LAN - ALL IP TRAFFIC OUTBOUND

The linked server between SQL LAN and WAN are working propperly.
I can to execute remote select statement with either servers.

But when I try to run a Begin Transaction, I get the following error:

http://support.microsoft.com/default.aspx?scid=kb;en-us;839279

But, this article don´t apply on this case.



TKS
Alex







Other related posts:

  • » ISA Between SQLs