By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,948 Members | 1,929 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,948 IT Pros & Developers. It's quick & easy.

Problems Upsizing to SQL Server 2005 Express Using Wizard

P: n/a
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.

Oct 12 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Wayne <cq*******@volcanomail.comwrote in news:1192165714.699479.161250
@k35g2000prh.googlegroups.com:
The dropdown at the top labelled "What SQL Server would you like to
use .........." says "(local)
My experience is that SQL Express installation defaults the server name to
ComputerName\SQLExpress

The server name on my laptop is
FFDBA-LAPTOP\SQLEXPRESS

In some connection utilities the server name is a pull-down which may list
available servers.

--
lyle fairfield
Oct 12 '07 #2

P: n/a
My experience is that SQL Express installation defaults the server name to
ComputerName\SQLExpress

The server name on my laptop is
FFDBA-LAPTOP\SQLEXPRESS

In some connection utilities the server name is a pull-down which may list
available servers.

--
lyle fairfield
Thanks for the reply Lyle. "(local)" is the only server name that is
available in the dropdown.

Oct 12 '07 #3

P: n/a
>
My experience is that SQL Express installation defaults the server name to
ComputerName\SQLExpress

The server name on my laptop is
FFDBA-LAPTOP\SQLEXPRESS

In some connection utilities the server name is a pull-down which may list
available servers.
Thanks for the reply Lyle. I just tried "MAIN\SQLEXPRESS" and it
works. Simple, but not very intuitive.

Oct 12 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.