Run Time Error -2147467259(80004005) : [DBNETLIB][ConnectionOpen(Connect()).}SQL Server does not exist or access denied.

[Ann]

Hi,

I have a VB6 application which connects to a SQL Server 2000 database
using ADO 2.5. About a dozen users have installed the application on
their machines and used it with no problems. One user is getting the
following error: Run Time Error -2147467259(80004005) :
[DBNETLIB][ConnectionOpen(Connect()).}SQL Server does not exist or
access denied. I can log on with his ID from my machine so I don't
think that it's a SQL Server security issue. I re-installed the
application on his machine and still get the error, even with my ID.
Is there something obvious that I should be looking for? Any help
would be appreciated.

Thanks,

Ann

[Kevin McDonnell [MSFT]]

Hi Ann,
You'll need to create a Test ODCB dsn to get the true error message to
tshoot this.
or try using ISQL.exe and connecting.
Eg.
ISQL -SserverNameHere -E
or
ISQL -SserverNameHere -Uuserid -Ppassword

Note the OS error returned. This will tell you what the real problem is.
Eg. 10061 == Connection Refused. Normally means the server is not
listening on TCP/IP

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

[Dan Artuso]

Hi,
How are you connecting? What is your connection string?
His ID, does that mean you're using SQL Server Authentication?
Can you ping the server from his machine?

--
HTH
Dan Artuso, Access MVP

Post by Ann
Hi,
I have a VB6 application which connects to a SQL Server 2000 database
using ADO 2.5. About a dozen users have installed the application on
their machines and used it with no problems. One user is getting the
[DBNETLIB][ConnectionOpen(Connect()).}SQL Server does not exist or
access denied. I can log on with his ID from my machine so I don't
think that it's a SQL Server security issue. I re-installed the
application on his machine and still get the error, even with my ID.
Is there something obvious that I should be looking for? Any help
would be appreciated.
Thanks,
Ann