Hello,
I am new to SQL Server. I am trying to use the Database
upsizing wizard to upsize a Access 2000 database into SQL
Server 2000. They are both on the same machine (running
Win 03 Server). I cannot connect to the SQL Server. Error
as below:

Connection failed:
SQLState: '01000'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][Shared Memory]
ConnectionOpen(Invalid Instance()).
SQLState: '08001'
SQL Server Error: 14
[Microsoft][ODBC SQL Server Driver][Shared Memory]Invalid

It might be related to your MDAC version, older MDAC versions cannot
recognize named instances.

274383 ACC2000: Cannot Connect to Instance of SQL Server 2000
http://support.microsoft.com/?id=274383

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.