Upsizing Wizard Access 2000

  • Thread starter Thread starter BillD
  • Start date Start date
B

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
 
BillD said:
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
 
Thanks for the advice. I will try the SSMA. I am having no luck with Access
upsizing wizard.

Peter Doering said:
BillD said:
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
 
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.

Peter Doering said:
BillD said:
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 said:
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]
Peter Doering said:
BillD said:
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
 
I used the SSMA you suggested. It worked flawlessly. Thanks again.
Bill Depow

Peter Doering said:
BillD said:
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
 
I forgot to tell you that SSMA installed and worked on my PC with Windows
2000 Pro.

Peter Doering said:
BillD said:
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]
Peter Doering said:
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
 
Back
Top