DBNETLIB error on connection

• jwalton

  SSC Rookie

  Points: 49

  More actions

  November 5, 2003 at 6:59 am

  #66156

  I'm running SQL 2000 with SP3a on an NT Server with SP6a. I am connecting to SQL thru a custom third party software. I have two locations on separate networks that must access the SQL server. Inhouse, anyone on any OS can access, however the remote site can only access the SQL thru a Win98 connection. Win2k and WinXP machines will not connect, they only give the following error:

  [DBNETLIB][ConnectionOpen (Connect()).]SQL server does not exist or access denied.

  All machines with permission can map a drive and browse the server containing SQL, but ONLY Win98 can actually connect to SQL remotely.

  I've played with the TCP/IP settings and Named Pipes as well, but to no avail. I'm not an SQL guru, just a basic net admin having to learn as I go. Why would Win98 connect remotely and nothing else will?

• rs

  SSCrazy

  Points: 2819

  More actions

  November 5, 2003 at 8:13 am

  #480912

  Looks like the client machine using named pipes (Default), try to change the connection to use TCP/IP.

• noeld

  SSC Guru

  Points: 96590

  More actions

  November 5, 2003 at 8:54 am

  #480923

  1- use odbcping from the clients and make sure the account can login.

  2- Check Client Network Utility and Server network utilities to verify both are in synch

  HTH

  
  * Noel