Error messages upsizing from MSAccess database to SQLServer

I am trying to use SQLServer for the first time and I am trying to use the upsizing wizard on Access to get moved over to SQLServer. I am getting the following error messages:

Connection failed:

SQLState: '01000'

SQL Server Error: 2

[Microsoft][ODBC SQL Server][Shared Memory]ConnectionOpen (Connect()).

Connection failed:

SQLState: '08001'

SQLServer Error: 17

[Microsoft][ODBC SQL Server][Shared Memory]SQL Server does not exist or access denied.

Does anyone know how I should proceed? Any help would be appreciated.

Thanks

Which version of SQL Server are you using?

Does the following help

http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx

|||I am using SQL Server 2005 Express|||Did you try the steps in the link I provided?|||

I did all the steps and I got the following error message:

ODBC - call failed.

I also tried this: I wrote a new database that had only one table in it (no forms or queries) and a few records in that table. That test database did get upsized just fine. But when trying to upsize the database I really need, I still got the "ODBC - call failed" error message.

Do you have any recommendations.

Thanks

Mark

|||

http://support.microsoft.com/?scid=kb;en-us;303257&spid=2509&sid=49

HTH