CariDotMy

 Forgot password?
 Register

ADVERTISEMENT

View: 1655|Reply: 4

MS Loopback Adapter

[Copy link]
Post time 30-11-2007 12:57 PM | Show all posts |Read mode
Nak tanya....
MS Loopback adapter ni software saja ke mmg ada ngn hardware skali...??
aku x tau la.....
TQ....
Reply

Use magic Report


ADVERTISEMENT


Post time 30-11-2007 02:50 PM | Show all posts

Reply #1 Sanjiyan_Unkara's post

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 ]
Reply

Use magic Report

 Author| Post time 5-12-2007 05:09 PM | Show all posts
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....
Reply

Use magic Report

Post time 5-12-2007 05:55 PM | Show all posts
nnt aku movekan topik ni ke bod networking.
Reply

Use magic Report

 Author| Post time 5-12-2007 08:24 PM | Show all posts
Originally posted by bzzts at 5-12-2007 05:55 PM
nnt aku movekan topik ni ke bod networking.


silap bod ke......???
sorry...
TQ mod....
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

 

ADVERTISEMENT


Forum Hot Topic

 

ADVERTISEMENT


 


ADVERTISEMENT
Follow Us

ADVERTISEMENT


Mobile|Archiver|Mobile*default|About Us|CariDotMy

13-12-2024 12:39 PM GMT+8 , Processed in 0.057085 second(s), 15 queries , Gzip On, Redis On.

Powered by Discuz! X3.4

Copyright © 2001-2021, Tencent Cloud.

Quick Reply To Top Return to the list