ODBC connection problem

Bergan2
Bergan2 used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
HainKurtSr. System Analyst

Commented:
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?
HainKurtSr. System Analyst

Commented:
have a look at this article from MS

http://support.microsoft.com/kb/328306

Author

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.  
Commented:
I restarted the services on the SQL express 2005 and the problem is resolved.

Thanks.

Author

Commented:
Thanks for your help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial