I am using a file DSN connection in an Access 2003 database to use linked SQL Server 2005 tables. I have one setup that works great (to 1 server/database). I am trying to setup another one (to a different server/database). I have a SQL user setup and I can connect fine via SQL Query Analyzer. However, when I try to add a file DSN (also tried a system DSN) using that SQL login; I get the following:
Connection failed:
SQLState '01000'
SQL Server Error: 2[DBNETLIB]ConnectionOpen (Connect()).
[Microsoft][ODBC SQL Server Driver]
Connection Failed
SQLState '08001'
Sql Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
Any ideas?
Thanks,
Nyneave