Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Administration  MS Access 2007 and SqlServer 2008 express

Author  Topic  gem1204 Starting Member 9 Posts Posted - 2011-02-03 : 09:38:38 I am having a problem connecting an MS Access 2007 ADP to an Sql Server 2008 Express Server. I installed SQL Server express 2008 on a machine running windows 7. When I try to connect to the server using an MS Access 2007 ADP. I get an error “Login Failed. Catalog information cannot be retrieved.” I tried connecting using the SA account, Windows Authenication, and with a user that I created that had SysAdmin permissions – nothing works. I CAN connect to the server using Sql Server management studio, I can create an odbc connection that works, and I can create an asp.net connection that works using Visual Studio 2008. It would seem that Access would be the problem but I can connect to an Sql Server 2008 Express database running on a remote server so I can’t figure out where the problem is. I previously had SQL Server 2005 express installed that worked ok. When I upgraded to SQL Server 2008 is the problem started. I have uninstalled and resinstalled Sql Server 2008 Express sever times and I’m still getting the same problem. Does anyone have any Idea what the problem could be? Could it be a problem with the registry? Thanks