RE: SQL 2005 Named Instance Connection

I'm not sure what the deal is with this but I decided to try and disable UDP
1434 as the more I read the more it seemed it's only required for a Dynamic
SQL Named Instance connection, where it needs to discover the port.

Although when I first tried not having UDP 1434 open it failed to connect to
the SQL2005 Named Instance (with a static port assigned), now when I try it
today it works fine without UDP 1434 being open.

I recall when I changed the port to static on SQL2005 that it prompted me
regarding not taking effect until the "service" is restarted, I restarted the
SQL Instance, perhaps something else needed to be restarted which has been
done between then and now.

Going to leave it just like it is, Static Port X opened, UDP 1434 Closed.

I'm happy.

Corey

"Corey" wrote:

Okay, I think I have worked it out - if you spot something wrong i.e.
dangerous configuration please let me know.

I had previously configured the SQL2005 Named Instance to use static port X,
and had then opened ISA port X without success, I have now done the following
and it appears to work fine:

1. Set SQL2005 Connection to static port X
2. Created new protocol on ISA which includes port X
3. Created new rule (2nd to bottom) opening port x and Microsoft SQL udp
port (1434) open for connections: from ISA2004 to SQL2005 computers only.

If anyone has anything to add please do so.

Cheers
Corey


"Corey" wrote:

Hello,

Can anyone tell me how I can configure my ISA2004 Server to allow a
connection to an SQL Named instance on another server, currently all other
pcs (on the network) can connect no problem.

When I run run the udl file I get the following error:
"Test connection failed because of an error in initializing provider.
[DBNETLIB]ConnectionOpen(Connect()).]SQL Server does not exist or access
denied".

All the computers are using the same udl connection, when I disable ISA2004
the connection works fine.

I need the ISA2004 server to connect to the SQL2005 Named instance as the
ISA2004 server also runs some software requiring a connection to the DB.

I have tried the following (basically setting a static port), no luck:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=135329&SiteID=1

Any help would be much appreciated.

Cheers
Corey
.

Relevant Pages

  • Re: Looking for tutorial
    ... TCP and UDP are different types of IP. ... TCP is a connection -- one machine sends connection request, ... Port numbers are a way for the software to try to tell the machine it's ...
    (comp.security.firewalls)
  • Re: bind() udp behavior 2.6.8.1
    ... clearing out a UDP connection in a firewall coming from a high port is ... Allowing a high numbered udp port to remain ... first connection which is what is causing the issue. ...
    (Linux-Kernel)
  • How to uniquely identify a UDP session at Winsock layer?
    ... Question on UDP at Winsock layer. ... Theoretically, I guess, a connection or session in uniquely identified ... by "Source IP, Source port, Destination IP, Destination port". ...
    (microsoft.public.development.device.drivers)
  • Re: determine if TCP or UDP port is working properly?
    ... For tcp you can try to telnet to the port on the other end as in [telnet ... would probably not get a connection but just a blinking cursor. ... Other ways are to try a network scanner that can scan tcp and udp such as Superscan4 ...
    (microsoft.public.win2000.networking)
  • Re: Correction
    ... Normally to physically disconnect is just a matter of reaching for the ... >> I have an ADSL connection which polls my computer from time to time, ... > disallow each and every port with Windows Firewall? ...
    (microsoft.public.windowsxp.messenger)
Loading