• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

ODBC connection problem

i have set up SQL Server Express 2005 as a backend and MS Access 2007 as a front end.  The operating system on both machines is Windows 7.  I have set the login and user name on the SQL Server.  I am trying to establish an ODBC connection between the Access 2007 to the SQL server and I keep getting an error message:
"Connection Failed
SQL State 01000
SQL Server Error 1385
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen
(Connect())
Connection failed:
SQL State 08001
SQL Server Error 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL server does not exist of access denied

I have this same system set up on XP boxes and no problems connecting using SQL server driver.

Please help.  Thanks.
0
Bergan2
Asked:
Bergan2
  • 3
  • 2
1 Solution
 
HainKurtSr. System AnalystCommented:
so you have 3 machines, one sql server 2 clients
one client can connect to sql using the same settings, the other is giving this error
is that right?
0
 
HainKurtSr. System AnalystCommented:
have a look at this article from MS

http://support.microsoft.com/kb/328306
0
 
Bergan2Author Commented:
I have two machines set up the  with Access 2007 and SQL Express 2005 with  operating system Windows 7.  

The other machines I referred to are a different system entirely using XP as the operating system but the same SQL express 2005 and Access 2007 programs.  This system works.  
0
 
Bergan2Author Commented:
I restarted the services on the SQL express 2005 and the problem is resolved.

Thanks.
0
 
Bergan2Author Commented:
Thanks for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now