Solved

loopback for MSSQL

Posted on 1998-02-07
7
792 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

756 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