Re: netbios and named pipes sql replication.
From: Combfilter (adsf_at_asdf.com)
Date: 09/08/04
- Next message: JimMac: "Managed vs. Automatic Identity Values"
- Previous message: faustino Dina: "Re: Merge works but the wrong way..."
- In reply to: DC Stewart: "Re: netbios and named pipes sql replication."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 8 Sep 2004 09:38:32 -0500
In article <10jrt6rrko7fc4e@news.supernews.com>,
donald.stewart2@alcoa.com says...
> -comb
>
> yes Named Pipes uses netbios.
>
> we had a situation after apply a MS patch to the SQL server which disabled
> netbios connections (security hole).
>
> Clients (ODBC) which had been setup to use TCP/IP would switch to named
> pipes if the TCP/IP connection could not be made or was dropped sometine in
> the life of the ODBC. Once the client switched to named pipes, it never
> switches back to TC/IP. It remains at the last protocol it made a good
> connection with.
>
> When we took named pipes support off the SQL server with the MS patch, those
> clients could not connect.
>
> We had to manually walk thru the ODBC setup and configure the CLIENT
> CONFIGURATION to use the TCP/IP library.
>
> Even if the client was using a native or 3rd party connector the client uses
> the last good connection library to make all subsequent connections to that
> SQL server.
> It is actually stored in the registry, but the easiest way to change it is
> thru an ODBC configuration.
>
> You may have a similar issue with the distributor server acting as the
> client in this case.
>
> DS
>
>
Thanks DS..
I believe this is exactally what is happening.
It's interesting to know that it defaults to the
last known good protocol. I figured it would
always try to connect with the first protocol in
the list.
I appreciate the info.
-comb
- Next message: JimMac: "Managed vs. Automatic Identity Values"
- Previous message: faustino Dina: "Re: Merge works but the wrong way..."
- In reply to: DC Stewart: "Re: netbios and named pipes sql replication."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
