odbc call failed

have server 2008 as DC
and Server 2003 running SQL server2000

When thinclient to Terminal services into 2003 server - can run access reports w/ no problem
A windows 2007 pc on network authenticates and runs access using database on 2003 server and get
ODBC-call failed
same ODBC, full rights
Can open database and see reports - but trying to run a report or open a table and it fails...
but not in 2003 server directly...
Who is Participating?
You need to ensure that the logged on user has permissions to access the sql database.  I have had the exact same problem.

Access front end / sql backend

Open management studio and set up appropriate permissions / logins

hope this helps
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.

All Courses

From novice to tech pro — start learning today.