Access Upsizing Wizard connection problem

I'm trying to use the Upsizing Wizard on an Access database to SQL Server
2005. When I try to create the database I get a popup - Microsoft SQL Server
Login - with the following information:
Connection failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][OBDC SQL Server Driver][DBNETLIB]ConnectionOpen(Conn
ect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Micrsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or
access denied.
I assume this is 2 different errors, but can someone explain what's going on
?
Dale CowanThese two errors usually mean that the SQL Server can't be located. Either
the server computer can't be found because of some network error, or the SQL
Server on the computer is not started, or the SQL Server on the computer is
not reachable because it's blocked behind the firewall, or the SQL Server is
not listening on remote port or pipes, or the instance name can't be
resolved to the port number (or pipe name), or you just typed the name
wrong. In short, it could be lots of things. For a start, I've written a
very short tutorial for SQL Server 2005 to help people with the most common
problems. It's at
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Dale" <Dale@.discussions.microsoft.com> wrote in message
news:579A2ED0-BB0C-4C41-B058-599DAA4D3F64@.microsoft.com...
> I'm trying to use the Upsizing Wizard on an Access database to SQL Server
> 2005. When I try to create the database I get a popup - Microsoft SQL
> Server
> Login - with the following information:
> Connection failed:
> SQLState: '01000'
> SQL Server Error: 53
> [Microsoft][OBDC SQL Server Driver][DBNETLIB]ConnectionOpen(Co
nnect()).
> Connection failed:
> SQLState: '08001'
> SQL Server Error: 17
> [Micrsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does no
t exist or
> access denied.
> I assume this is 2 different errors, but can someone explain what's going
> on?
> --
> Dale Cowan