When trying to use the Access 2007 upsizing wizard to move a database to SQL Server 2005 Express, I get the following error message:
SQL Server Error: 2
[Microsoft][ODBC SQ Server Driver][Share
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server
does not exist or access denied.
I get the same message regardless of whether I configure SQL Server to run as a local system or service.
I am the only user on my Vista 32 PC and am therefore the administrator. As far as I can tell I have sufficient authority since I can start and stop SQL Server.
As a newbie to all this, I can't find any step by step instructions as to how a local copy of SQL Server should be configured to work with the upsizing wizard. In fact I can't even find any Access 2007 help walk-throughs on this upsizing wizard, let alone troubleshooting its error messages.
Any help would be appreciated, as well as links to step by step instructions (which I can't find in the MSDN Library materials).
PS Does MS understand how inadequate and inefficient its built-in documentation really is? Maybe that's what keeps MS Press in business!
View Complete Post