0

I have installed SQL Server 2000 on two different laptops (laptop 'A' and laptop 'B'). 'A' should connect to 'B' after creating a linked server connection on 'A'.

This step goes well but when I open the query analyzer trying on 'A' to do a select statement from one of the databases of 'B' , I get this error

SQL Server does not exist or access denied

The weird part is that when I try to run the statement after a while it works fine and it returns the expected results. Waiting another bit, then trying to run the statement, I get the same error again.

Both laptops are connected to a WIFI access point.

Any help is much much appreciated .

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Bilal Harb
  • 29
  • 6
  • 1
    WiFi. Db Connections. Nooooooo. Seriously - there's nothing strange about packet loss and WiFi connections failing. And SQL Server 2000 is older than WiFi. Even if newer versions can handle intermittent connection loss, that old version couldn't – Panagiotis Kanavos Jul 20 '15 at 06:53
  • It looks more like general network issue to me. I would assign static IP addresses to your laptops and link SQL server by IP address. Of course such setup would work only in static network context - using always same wifi router/ap. – Arvo Jul 20 '15 at 07:01

1 Answers1

0

Thanks guys for your suggested solutions. I tried Ethernet connection instead and the linked server connection works perfectly .

Bilal Harb
  • 29
  • 6