Cannot connect to SQL 2000 remotely

I'm trying to install a bespoke application for a new client, and am
embarassed by not being able to connect to their DB Server.

The server and clients are XP all running on a workgroup called OFFICE

File access is not problem and the DB Server name appears in a dropdown box
of SQL servers on the network - e.g. when trying to create an ODBC DSN.

The SQL Server is now configured to accept Windows and SQL authentication
connection requests - and restarted.

I have switched off or uninstalled everything that looks like a firewall on
both server and clients.

When trying to set up local ODBC DSN to connect as sa, I can connect no
problem, but from one of the client laptops I just get the error:

"Access denied or SQL Server does not exist"

Can anyone tell me where else to look or what else to try?

Is there a step by step procedure which could take me to the cause of the
problem?

The network is a wireless Lan - and IPX/SPX is featuring in the network
stack. Could that be something to do with it?

Any help very very much appreaciated!

Thank you

Clive (London UK)







.

Relevant Pages

  • RE: Printing from Win9x clients stops
    ... Open Server Management. ... then right-click the name of the computer running Windows Small Business ... >From the client computer: ... The Select Network Component Type ...
    (microsoft.public.windows.server.sbs)
  • RE: Printing from Win9x clients stops
    ... The printers with 9x drivers on the server appeared automatically in the ... > then right-click the name of the computer running Windows Small Business ... > From the client computer: ... The Select Network Component Type ...
    (microsoft.public.windows.server.sbs)
  • Re: Daily Server Report (Critical Errors, Event ID: 537)
    ... Does this issue happen on client workstation or server? ... Does your server and all clients' workstation work well now? ... issue in your Network? ...
    (microsoft.public.windows.server.sbs)
  • Re: Small business thinking about backing up data, having a server and 2-3 users - is SBS200
    ... is networked to the Master with a crossover network cable. ... Master on the Master PC and Client on the Slave pc. ... Since this machine is a server is should handle the requests ok ... Most real firewall appliances have HTTP and SMTP proxy services that allow ...
    (microsoft.public.windows.server.sbs)
  • RE: Private addresses on public network
    ... anybody accesses those computers from an external network," -- even when the ... JavaScript delivered to the client that causes the client to retrieve ... the attacker, the request results in another JavaScript response that tells ... Moving beyond a single server ...
    (Security-Basics)