Port 1025???

From: Guy Kopel (guy@spiralsolutions.com)
Date: 03/31/03 

From: "Guy Kopel" <guy@spiralsolutions.com>
Date: Mon, 31 Mar 2003 13:39:23 +0300

Hi,
We have 2 MS-SQL 2000 servers in two different location, one is on our DMZ
and the other one is located at our hosting provider (cluster server),
my problem is when our developers try to do an update from the DMZ to the
cluster server we get the error:
Updating remote XXXXX table. Wait...
Server: Msg 7391, Level 16, State 1, Procedure XXXXUpdate, Line 11
The operation could not be performed because the OLE DB provider 'SQLOLEDB'
was unable to begin a distributed transaction.

I have looked into our firewall logs (checkpoint) and saw that the cluster
server is trying to send packages back to the SQL in the DMZ to port #
1025?!?
I have open this port for testing and it worked well, I don't like to leave
this port open cause I don't know why it's using this port and this is not
recognized port for MS-SQL

Can anyone explain why it's using this port and if I can change it?

(PS:I'm not expert in MS-SQL so please try to make it simple for me :-)

Thanks.

Relevant Pages

  • Re: client cant connect when instance on one particular node
    ... Best practice is to specify a specific port and then code the client to ... SQL 2000 SP4 for SQL version. ... Then server guys evicted ... cluster configuration. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Unable to join AD domain from DMZ network
    ... the server from the DMZ registered the ... unless you lock it down to a specific port. ... authentication from DMZ to 2003 AD internal network. ...
    (microsoft.public.windows.server.active_directory)
  • Re: How to Create a TCP/IP PrinterPort on a MS Cluster 2k3 via Scr
    ... XP is not in the cluster so I'm not clear on the failure question. ... the user running the script should be admin on the remote print server. ... thus the creation of the port on the node. ...
    (microsoft.public.windows.server.clustering)
  • Re: How to Create a TCP/IP PrinterPort on a MS Cluster 2k3 via Scr
    ... XP is not in the cluster so I'm not clear on the failure question. ... the user running the script should be admin on the remote print server. ... thus the creation of the port on the node. ...
    (microsoft.public.windows.server.clustering)
  • Re: OWA connectivity
    ... First though I'd like to admit I made a mistake in talking about SMTP port ... Secondly opening these ports from your DMZ towards your LAN is not insecure ... Whether or not you use a proxy server in this setup is up to you. ... I feel is not a true firewall and should be used as ...
    (microsoft.public.exchange.admin)