|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Connection failed error during upsizing of an Access database to SQl Server Express databaseIn 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 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 |
|||||||||||||||||||||||