Monday, March 26, 2012

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

No comments:

Post a Comment