Connection failed error during upsizing of an Access database to SQl Server Express databa

Hello,
In order to utilize an Access database as SQL Server database I use
Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
wait I get the following error:
Connection failed:
SQL State:'01000'
SQL error Error:2
[Microsoft][ODBC Server Driver][Shared
Memory]ConnectionOpen(Connect())
Connection Failed:
SQL State:'08001'
SQL server Error:17
[Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
exist or access is denied
Under VS2008 I can connect to Northwind SQLServer Express database and
manipulate the data OK. So what can I do? Thank you.
Athena
Hello,
I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.
Athena
"Athena" <Nospam@.nospam.com> wrote in message
news:4616FCF7-A008-4D57-9FBE-480455B4E162@.microsoft.com...
> Hello,
> In order to utilize an Access database as SQL Server database I use
> Upsize wizard. I use (Local) SQL server and Trusted Connection. After some
> wait I get the following error:
> Connection failed:
> SQL State:'01000'
> SQL error Error:2
> [Microsoft][ODBC Server Driver][Shared
> Memory]ConnectionOpen(Connect())
> Connection Failed:
> SQL State:'08001'
> SQL server Error:17
> [Microsoft][ODBC Server Driver][Shared Memory]SQL Server does not
> exist or access is denied
> Under VS2008 I can connect to Northwind SQLServer Express database and
> manipulate the data OK. So what can I do? Thank you.
> Athena