Upsizing Wizard Access 2000

[BillD]

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

Any help greatly appreciated
Bill Depow

 

[Peter Doering]

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[BillD]

Thanks for the advice. I will try the SSMA. I am having no luck with Access
upsizing wizard.

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[BillD]

The SSMA sounded good but this machine uses Windows 2000 Pro. A requirement
for SSMA is Windows XP SP2. I will try the upsizing wizard again.

Thanks, Bill D.

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[Peter Doering]

The SSMA sounded good but this machine uses Windows 2000 Pro. A requirement
for SSMA is Windows XP SP2. I will try the upsizing wizard again.

Well, you don't have to perform the migration on the same machine. A
workstation running WXPsp2, with access to both, mdb and SQL Server will
do.

--
Peter Doering [MVP Access]

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[BillD]

I used the SSMA you suggested. It worked flawlessly. Thanks again.
Bill Depow

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[BillD]

I forgot to tell you that SSMA installed and worked on my PC with Windows
2000 Pro.

The SSMA sounded good but this machine uses Windows 2000 Pro. A requirement
for SSMA is Windows XP SP2. I will try the upsizing wizard again.

Well, you don't have to perform the migration on the same machine. A
workstation running WXPsp2, with access to both, mdb and SQL Server will
do.

--
Peter Doering [MVP Access]

BillD wrote:

I have split my database into a front end and a back end. The back end
contains only the tables. I installed SQL Server 2005 Express. When I use the
upsizing wizard I select "create new database" The next question is "What
SQL Server would you like to use for this database?" I select the only choice
"(Local)" Then I am asked for the Login Id and password. After I enter the
login and password 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

1. Login

Various reasons are possible for this error. Setup of SQL Express per
default doesn't allow remote connections. You have to switch that on using
SQL-Server Configuration Manager (Network Configuration, change TCP/IP to
Enabled). If the protocol is enabled already and you still don't see the
correct instance, start SQL Server Browser Service.

2. Upsizing Wizard

Instead of the upsizing wizard you should use SSMA. It is more reliable,
less work afterwards:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

 

[Peter Doering]

I used the SSMA you suggested. It worked flawlessly. Thanks again.
Bill Depow

Thanks for the feedback.

 

[Jenny Steenssens]

Thanks for the feedback.