Solved

loopback for MSSQL

Posted on 1998-02-07
7
750 Views
Last Modified: 2012-06-27
Can I have loopback and network support on the same machine.
Where can I find this loopback driver for MSSQL?
Does anyone have it and can anyone help on this one?
0
Comment
Question by:alvinwang
  • 4
  • 3
7 Comments
 
LVL 1

Accepted Solution

by:
kuk010998 earned 30 total points
Comment Utility
Not sure I fully understand your problem but -
a) You need network support to install or operate MS SQL server.
b) In case you do not have a physical network you can install a dummy network board - the MS loopback adapter - which is part of every NT since version 3.1.
c) If you are using SQL workstation, a single-machine developer version of SQL server, its setup should take care of that automatically.
0
 
LVL 1

Author Comment

by:alvinwang
Comment Utility
HI,
one of the PC is connected to a local network. So wat else should I do to it? I download the evaluation copy of MSSQL from microsoft site some time back. Is it the same, does the evaluation copy comes with this loopback?
How do I know my NT serrver 4.0 has network loopback support. Do I ping 127.0.0.1 ? or wat do I do ?
What's an SQL workstation ? DOes it comes with the evaluation copy too?
thanks.



0
 
LVL 1

Expert Comment

by:kuk010998
Comment Utility
>one of the PC is connected to a local network.
Then it already has the necessary services. If it is NT Server and has enough RAM it should be able to run SQL server.
>evaluation copy of MSSQL from microsoft site
Am not sure about the differences...
>How do I know my NT server 4.0 has network loopback support.
The point is, SQL Server *needs* the NT networking software. If your target machine is networked, go on. If not, you need to install NT´s networking which in turn requires a network adapter. You do not have one, so you need to install a dummy network board - the driver is called "MS loopback adapter". It is included with NT. Loopback per se is no requirement for SQL Server.
>Do I ping 127.0.0.1 ? or wat do I do ?
This IP number - yes it also is called loopback - has no direct relation to either the MS loopback adapter or SQL Server. You do not need TCP/IP at all to run SQL Server. As soon as you can successfully install the product, the requirements adressed by the loopback issue are met.
>What's an SQL workstation?
SQL Workstation is a MS product - a special version of SQL Server trageted at developers, tailored to run on a single machine, and priced at about one-half of the full product. Your demo package should be similar to it, but not identical.

0
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
LVL 1

Author Comment

by:alvinwang
Comment Utility
how do I know I have this loopback? How do I test that I hjave loopback included.


0
 
LVL 1

Expert Comment

by:kuk010998
Comment Utility
Again: You do not need loopback. You need the NTnetworking stuff. The MS loopback adapter is just a kludge to get these functions in when your PC has no network board.
Another thing not clear from my last comment: SQL Workstation relaxes the NT Server requirement, it also runs on NT Workstation - hence the name.
0
 
LVL 1

Author Comment

by:alvinwang
Comment Utility
I've got the loopback working, but when I try to use ISQL/W , I annot see any server available, anyone can help.

0
 
LVL 1

Expert Comment

by:kuk010998
Comment Utility
" anyone can help." - probably not, this already has status PAQ as you accepted my answer. That you see no server available in the dropdown list is more or less normal I´m afraid - just type in the computer name of your SQL server to connect. To explain the circumstances you need to have that server list valid would be a new question...
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now