MS Loopback Adapter

Sanjiyan_Unkara · Post time 30-11-2007 12:57 PM

Nak tanya....
MS Loopback adapter ni software saja ke mmg ada ngn hardware skali...??
aku x tau la.....
TQ....

bzzts · Post time 30-11-2007 02:50 PM

SUMMARY
http://support.microsoft.com/kb/236869

The Microsoft Loopback adapter is a tool for testing in a virtual network environment where access to a network is not feasible. Also, the Loopback adapter is essential if there are conflicts with a network adapter or a network adapter driver. Network clients, protocols, and so on, can be bound to the Loopback adapter, and the network adapter driver or network adapter can be installed at a later time while retaining the network configuration information. The Loopback adapter can also be installed during the unattended installation process.

What is the Microsoft Loopback adapter and why do I need it for SQL Server?
http://www.windowsitpro.com/Article/ArticleID/14400/14400.html

A. SQL Server is dependent on network functionality - even for the set-up routines. Specifically it needs to use named-pipe/mailslot functionality on NT machines. These usually require a network card to be present. If you don't have a network card then go to control panel/networks, choose add adapter and then add the Microsoft loopback adapter - which is just a dummy driver, no hardware involved. This needs to have working network protocol(s) bound to it. Let whichever protocols you have use default parameters, EXCEPT for tcp-ip. If you are using this then do NOT specify dhcp assigned address, use 192.168.1.1 as the IP address and 255.255.255.0 as the subnet mask. This is a standard RFC1918 non-routed IP address so shouldn't clash with any dial-up address you may be given by an ISP.

If the server service does not start after installing the loopback adapter and you get the following message in the event log, then you need to re-install your *NT* service pack to synchronise your NT networking files. "The server service terminated with the following error: Not enough server storage is available to process this command"

One way of testing that the named-pipes functionality works is to run the makepipe and readpipe utilities that come with SQL Server. Run makepipe in one command window. Then run readpipe in another. If these work (i.e. the readpipe connects to makepipe and closes it down) then it is a good indication that networking functionality is ok.

For Win9x machines you don't need a loopback adapter to install but you do need to have the "MS Network Family Driver" installed and the default network client.

[ Last edited by bzzts at 30-11-2007 02:51 PM ]

Sanjiyan_Unkara · Post time 5-12-2007 05:09 PM

aku dah try install loopback adapter ni kat satu pc...
tapi bila dah install dia tulis "This connection have no connectivity".
camna nak wat ar..?
tolong....