SQL7 Runs on Network, not Standalone

  • Help! I have SQL Server 7.0 installed as a desktop configuration on Windowz 98. I have been been using a DHCP server assign my IP addresses and it has run fine for years. I recently changed my network to a domain with a domain server.

    Now when I disconnect my laptop from my network, I can no longer make a connection to the running engine on the laptop. In other words, Enterprise manager, Query Analyzer, ODBC Manager, etc. all do not acknowledge the running engine's existence.

    Any ideas of how to fix this problem?

    Thank you for any insight you can provide.

    Dirk


    Dirk

  • Use the Client Network Utility. In the Alias screen, add an alias using the TCP/IP network library. Put the server's name in the "Server alias:" textbox and type 127.0.0.1 into the "Server name:" textbox.

    Using the dotted address as "name" bypasses DNS, and 127.0.0.1 is the loopback address.

    --Jonathan



    --Jonathan

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply