Netbios and SQL Server Startup Procedure

Is there any way to configure MS SQL Server 2000 standard/developer to choose
a different name other than the netbios machine name as the "server" identity
during startup.
We are currently haveing issues with the assignment of a netbios alias that
SQL Server 2000 reads on it's startup that is different than the name of the
default instance.
TIA,
Hi
Have you checked out
http://msdn.microsoft.com/library/de...stall_5r8f.asp
John
"Dax Lawless" wrote:

> Is there any way to configure MS SQL Server 2000 standard/developer to choose
> a different name other than the netbios machine name as the "server" identity
> during startup.
> We are currently haveing issues with the assignment of a netbios alias that
> SQL Server 2000 reads on it's startup that is different than the name of the
> default instance.
> TIA,
|||That is interesting, however, that is not actually what is happening. The
machine name is actually staying the same as far as the TCP/IP properties are
concerned. We are simply assigning an alias during the startup sequence of
our failover maintenance software (Legato AAM) for a piece of 3rd party
software to use.
Unfortunately, it seems that SQL Server 2000 is reading this netbios alias
and thinks that the servername and when it compares that name with the name
of the default instance (which is not the alias), it treats the default
instance as a named instance and refuses to start listening at port 1433 as
it should with the default instance (we are not using any named instances in
our SQL Server 2000 configuration).
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked out
> http://msdn.microsoft.com/library/de...stall_5r8f.asp
> John
> "Dax Lawless" wrote:
|||Hi
Have you looked at creating an alias in the client networking utility,
or you may possibly be able to overcome it by adding the name to the
the hosts file?
John

Netbios and SQL Server Startup Procedure

Is there any way to configure MS SQL Server 2000 standard/developer to choose
a different name other than the netbios machine name as the "server" identity
during startup.
We are currently haveing issues with the assignment of a netbios alias that
SQL Server 2000 reads on it's startup that is different than the name of the
default instance.
TIA,Hi
Have you checked ou
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
John
"Dax Lawless" wrote:
> Is there any way to configure MS SQL Server 2000 standard/developer to choose
> a different name other than the netbios machine name as the "server" identity
> during startup.
> We are currently haveing issues with the assignment of a netbios alias that
> SQL Server 2000 reads on it's startup that is different than the name of the
> default instance.
> TIA,|||That is interesting, however, that is not actually what is happening. The
machine name is actually staying the same as far as the TCP/IP properties are
concerned. We are simply assigning an alias during the startup sequence of
our failover maintenance software (Legato AAM) for a piece of 3rd party
software to use.
Unfortunately, it seems that SQL Server 2000 is reading this netbios alias
and thinks that the servername and when it compares that name with the name
of the default instance (which is not the alias), it treats the default
instance as a named instance and refuses to start listening at port 1433 as
it should with the default instance (we are not using any named instances in
our SQL Server 2000 configuration).
"John Bell" wrote:
> Hi
> Have you checked out
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_afterinstall_5r8f.asp
> John
> "Dax Lawless" wrote:
> > Is there any way to configure MS SQL Server 2000 standard/developer to choose
> > a different name other than the netbios machine name as the "server" identity
> > during startup.
> >
> > We are currently haveing issues with the assignment of a netbios alias that
> > SQL Server 2000 reads on it's startup that is different than the name of the
> > default instance.
> >
> > TIA,|||Hi
Have you looked at creating an alias in the client networking utility,
or you may possibly be able to overcome it by adding the name to the
the hosts file?
John

Netbios and SQL Server Startup Procedure

Is there any way to configure MS SQL Server 2000 standard/developer to choos
e
a different name other than the netbios machine name as the "server" identit
y
during startup.
We are currently haveing issues with the assignment of a netbios alias that
SQL Server 2000 reads on it's startup that is different than the name of the
default instance.
TIA,Hi
Have you checked out
http://msdn.microsoft.com/library/d...nstall_5r8f.asp
John
"Dax Lawless" wrote:

> Is there any way to configure MS SQL Server 2000 standard/developer to cho
ose
> a different name other than the netbios machine name as the "server" ident
ity
> during startup.
> We are currently haveing issues with the assignment of a netbios alias tha
t
> SQL Server 2000 reads on it's startup that is different than the name of t
he
> default instance.
> TIA,|||That is interesting, however, that is not actually what is happening. The
machine name is actually staying the same as far as the TCP/IP properties ar
e
concerned. We are simply assigning an alias during the startup sequence of
our failover maintenance software (Legato AAM) for a piece of 3rd party
software to use.
Unfortunately, it seems that SQL Server 2000 is reading this netbios alias
and thinks that the servername and when it compares that name with the name
of the default instance (which is not the alias), it treats the default
instance as a named instance and refuses to start listening at port 1433 as
it should with the default instance (we are not using any named instances in
our SQL Server 2000 configuration).
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> Have you checked out
> http://msdn.microsoft.com/library/d...nstall_5r8f.asp
> John
> "Dax Lawless" wrote:
>|||Hi
Have you looked at creating an alias in the client networking utility,
or you may possibly be able to overcome it by adding the name to the
the hosts file?
John

netbios and sql replication

If i have netbios enabled on the distributor is there any way to make it
not request netbios information to the subscriber? I have the
subscriber in the host file and in the client network utility. That
should halt nebios request, but it doesn't. The subscriber keeps seeing
netbios request coming from our distributor?
Would adding the subscriber to the lmhost help more then adding it to
the host?
thanks,
comb
probably not. Hostname resolution goes through a hierarchy trying to resolve
the hostname, sometimes Netbios cache, WINS server first, broadcast,
lmhosts, hosts, DNS, sometimes DNS (if the host name has a . in it) first.
It depends on a variety of settings.
Why is this important to you. Once the server knows about a name it caches
it and doesn't do the lookup again.
"combfilter" <asdf@.adsf.com> wrote in message
news:MPG.1cc9e0a2c18ba491989680@.news.newsreader.co m...
> If i have netbios enabled on the distributor is there any way to make it
> not request netbios information to the subscriber? I have the
> subscriber in the host file and in the client network utility. That
> should halt nebios request, but it doesn't. The subscriber keeps seeing
> netbios request coming from our distributor?
> Would adding the subscriber to the lmhost help more then adding it to
> the host?
> thanks,
> comb
|||Our subscriber is complaining about netbios request from our distributor
in their firewall logs.
The subscriber is in the host file so our machine shouldn't even need to
do a netbios request. However, for some reason it is. Also, the host
file does work. I can make changes to it and they take place
immediatly.
Mostly I just want to stop it to make the subscriber happy.
In article <#nf51xfQFHA.3704@.TK2MSFTNGP12.phx.gbl>,
hilary.cotter@.gmail.com says...
> probably not. Hostname resolution goes through a hierarchy trying to resolve
> the hostname, sometimes Netbios cache, WINS server first, broadcast,
> lmhosts, hosts, DNS, sometimes DNS (if the host name has a . in it) first.
> It depends on a variety of settings.
> Why is this important to you. Once the server knows about a name it caches
> it and doesn't do the lookup again.
> "combfilter" <asdf@.adsf.com> wrote in message
> news:MPG.1cc9e0a2c18ba491989680@.news.newsreader.co m...
>
>
sql

netbios and named pipes sql replication.

A client that we replicate to is receiving some
netbios request that are originating from our
distribution server. I looked in the protocol
section to see which protocol is on top. I
assume the one on top is the order of which
protocol it will try to use first. Both us and
the subscriber have tcp/ip listed first.
However, they are receiving netbios request from
our machine. We have netbios over tcp/ip
disabled. Therefore, i am guessing that the
distributor is trying to use named pipes to
communicate. Is this correct? Does named pipes
even use netbios for discovery?
tia..
-comb
-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
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1ba7a7e4990ef73c9896a7@.news.newsreader.co m...
> A client that we replicate to is receiving some
> netbios request that are originating from our
> distribution server. I looked in the protocol
> section to see which protocol is on top. I
> assume the one on top is the order of which
> protocol it will try to use first. Both us and
> the subscriber have tcp/ip listed first.
> However, they are receiving netbios request from
> our machine. We have netbios over tcp/ip
> disabled. Therefore, i am guessing that the
> distributor is trying to use named pipes to
> communicate. Is this correct? Does named pipes
> even use netbios for discovery?
> tia..
> -comb
|||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