Unable to connect to SQL Server through ODBC

[Rob Buonocore]

I have an Access database that has linked table to an SQL server
database. The database is on a remote server.

I distributed the Database to 10 users. 9 users work great. The 10th
is unable to connect. There must be something on her machine that is
blocking it. It tells her that the database doesn't exist.

Is there any settings on the user side that could be blocking this
connection. Please email me if you can provide any help.
robbuo...@infocore.us

Rob Buonocore

[Erland Sommarskog]

[posted and mailed, please reply to the newsgroup]

There can be all sorts of this. There may an incorrect entry in
system32/drivers/etc/hosts. There could be an incorrect alias set up
in the Client Configuration. There could also be problems in active
directory.

A start is to open a command-line window and run

ping SERVER

If there is no contact, the problem is not SQL Server-related but a
general problem. If you are able to ping the server, the error is likely
to be in the client configuration, or an incorrectly set data source.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx