Re: Cannot connect to SQL 2000 remotely

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Glad to help. I recognize customers stress and confusion as a problem that we (Microsoft) often cause... and have an obligation to resolve.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Clive" <clive.elsworth@xxxxxxxxxxxxxxxxx> wrote in message news:O7J9R4pzHHA.3400@xxxxxxxxxxxxxxxxxxxxxxx
Apologies for flame throwing. Default of DisableNetworkProtocols WAS the problem, but in any case

thank for taking the time and trouble to get back to me Rick.

Clive Elsworth




"Rick Byham, (MSFT)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1CAB65A1-509E-4338-8C33-65D98FDA7300@xxxxxxxxxxxxxxxx
On the server, from the Start menu, point to All Programs, point to Microsoft SQL Server, and then click Server Network Utility. That utility should help you understand if SQL Server is using the IPX/SPX or TCP/IP protocols, which might indicate a problem. On the client there is a similar program, the Client Network Utility. Obviously the client and server should be using the same protocols.
--
Rick Byham (MSFT)
This posting is provided "AS IS" with no warranties, and confers no rights.

"Clive" <clive.elsworth@xxxxxxxxxxxxxxxxx> wrote in message news:OxUCSSVyHHA.5856@xxxxxxxxxxxxxxxxxxxxxxx
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)