Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 823
  • Last Modified:

loopback for MSSQL

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
alvinwang
Asked:
alvinwang
  • 4
  • 3
1 Solution
 
kuk010998Commented:
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
 
alvinwangAuthor Commented:
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
 
kuk010998Commented:
>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
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!

 
alvinwangAuthor Commented:
how do I know I have this loopback? How do I test that I hjave loopback included.


0
 
kuk010998Commented:
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
 
alvinwangAuthor Commented:
I've got the loopback working, but when I try to use ISQL/W , I annot see any server available, anyone can help.

0
 
kuk010998Commented:
" 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!

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now