Solved

loopback for MSSQL

Posted on 1998-02-07
7
778 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

776 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