RE: ISA/SQL Problem

Hi Alex,

Does it use RPC? Try disabling the RPC filter to test it. What do the
log files say? I didn't know that SQL used dynamic port assignments.
Learn something new every day :)

Tom
www.isaserver.org/shinder
Get the book!
Tom and Deb Shinder's Configuring ISA Server 2004
http://tinyurl.com/3xqb7
MVP -- ISA Firewalls



-----Original Message-----
From: Alex Decarli [mailto:adecarli@xxxxxxxxxxxxxxxxx] 
Sent: Thursday, September 30, 2004 3:37 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA/SQL Problem


http://www.ISAserver.org

The name resolution is ok, it works in this solution.
The problem is when I start "Begin Transaction" in a started connection.

I'm not sure, but I belive some resources of Begin transaction are using
RPC
and ISA is blocking RPC.
But there's "ANY RPC Data" Server rule created.


TKs




-----Original Message-----
From: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxx] 
Sent: quinta-feira, 30 de setembro de 2004 17:25
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA/SQL Problem

http://www.ISAserver.org

Hi Alex,

For most of these it's a name resolution issue.

Tom
www.isaserver.org/shinder
Get the book!
Tom and Deb Shinder's Configuring ISA Server 2004
http://tinyurl.com/3xqb7
MVP -- ISA Firewalls



-----Original Message-----
From: Alex Decarli [mailto:adecarli@xxxxxxxxxxxxxxxxx]
Sent: Thursday, September 30, 2004 2:51 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: ISA/SQL Problem


http://www.ISAserver.org


Hi TOM, thanks for reply.


Sorry,

The rules are "Server Publish" not "Web Publish" and the error is:

http://support.microsoft.com/?kbid=839279

The error is the same, but this article don't apply.
The test method on the end of the article is perfect to test this error



Others details:


- Remote select statement in either servers are ok
- Linked servers in either servers are ok


TKS
 

-----Original Message-----
From: Thomas W Shinder [mailto:tshinder@xxxxxxxxxxx]
Sent: quarta-feira, 29 de setembro de 2004 14:23
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQL / ISA problem

http://www.ISAserver.org

This one must be for Thor :-)

-----Original Message-----
From: Alex Decarli [mailto:adecarli@xxxxxxxxxxxxxxxxx]
Sent: Wednesday, September 29, 2004 12:07 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] SQL / ISA problem


http://www.ISAserver.org



Hi Mrs,

I've probelm with SQL Communication between ISA 2000 Server

Scenario
=========

MS-SQL Server A                                      MS-SQL Server  B
(network 1) --------->   ISA Server 2000  --------->   (network 2)

(last updates, every)


Problem
=======

MS-SQL Server A is talking with MS-SQL Server A throught 1433 port It
working propperly. 

But when MS-SQL Server A try to start a "Begin Transaction" it get the
following error:


If I establish a direct connection (without ISA Server) it work.
My ISA rules are:

Rule type......: WEB PUBLISHING
Destination Set: MS-SQL Server B
Rule port......: 1433 inbound

Rule type......: WEB PUBLISHING
Destination Set: MS-SQL Server B
Rule port......: Any RPC inbound (test)
 


Any help is very appreciated,


TKS
Alex





------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
adecarli@xxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx




------------------------------------------------------
List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist
ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp
ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ
------------------------------------------------------
Other Internet Software Marketing Sites:
World of Windows Networking: http://www.windowsnetworking.com
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
tshinder@xxxxxxxxxxxxxxxxxx
To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist
Report abuse to listadmin@xxxxxxxxxxxxx

Other related posts: