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