I've just installed SQL Server 2005 Express together with SQL
Management Studio Express on my local machine and I'm trying to upsize
a data mdb to SQL Server using the upsizing wizard. The data mdb is
also on my local machine. I've been at it for a couple of hours now
and I keep getting the same error despite trying everything I can
think of:
Connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]Connection Open
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.
The upsizing wizard dialogue box has the following information in it:
The dropdown at the top labelled "What SQL Server would you like to
use .........." says "(local)"
The "Use Trusted Connection" box is ticked.
The "What do you want to name your new SQL Server database?" box
contains the name that Access has assigned to it "ProdDBDataSQL".
When I click the "Next" button it thinks about it for a while and then
returns the error above.
In the "SQL Server Configuration Manager" I've gone into the "SQL
Server 2005 Services" and then into "SQL Server (SQLEXPRESS) in the
right hand panel and looked at the properties.
In the "Logon" tab:
"Log on as:" has "Built-in account" selected and "Local System"
appears in the drop down. I've tried the other options in the drop
down but they won't give me a connection either. Obviously the
"Service Status" is "Running".
I haven't touched anything under the "Service" and "Advanced" tabs.
Under "SQL Server 2005 Network Configuration"/"Protocols For
SQLEXPRESS" I've enabled "Named Pipes", "TCP/IP" and "Via". Given
that everything is on my local drive, I don't think these would have
any bearing on my problem. I've also enabled everything under "Client
Protocols".
I've run out of ideas. Any help would be greatly appreciated.
