Solved

loopback for MSSQL

Posted on 1998-02-07
7
766 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
ID: 1090209
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
ID: 1090210
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
ID: 1090211
>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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 1

Author Comment

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


0
 
LVL 1

Expert Comment

by:kuk010998
ID: 1090213
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
ID: 1090214
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
ID: 1090215
" 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

862 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

23 Experts available now in Live!

Get 1:1 Help Now