Home All Groups Group Topic Archive Search About

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

Author
8 Nov 2007 8:27 PM
Athena
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

Author
8 Nov 2007 9:31 PM
Athena
Hello,

    I found what's wrong. Server name comes by default as (local) I changed
to right one. It worked.

Athena
Show quote
"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

AddThis Social Bookmark Button