How can I install SQL 6.5 on my home WinNT WorkStation?
Check that you have installed a network adapter and protocol on your computer.
If your computer is not connected to the network, install the MS Loopback adapter
(Start -> Settings -> Control Panel -> Network -> Adapters -> Add),
add TCP/IP protocol
(Start -> Settings -> Control Panel -> Network -> Protocols -> Add),
and set TCP/IP address
(for example: IP Address: 192.168.0.1 and Subnet Mask: 255.255.255.0).
Now SQL Server 6.5 installation should pass successfully, but to register server
(option Register Server) you should choose the name of your computer
(Start -> Settings -> Control Panel - > Network -> Identification ->
computer name), or enter (local), or enter single dot character "."
as the computer name.
This article describes how to use MS Loopback adapter and tcp/ip: