Upsizing wizard access Sql Server express

[philip260]

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.


What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.

thanks in advance for your help.

 

[Sylvain Lafontaine]

Maybe a connection problem. First, you should try with SSMSE (Sql Server
Management Studio Express) to see if you can connect correctly. You can
also try using the SSMA for Access instead of the wizard to upgrade your
database.

Troubleshooting connection problem:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
http://msdn2.microsoft.com/en-us/library/ms345318.aspx
http://www.datamasker.com/SSE2005_NetworkCfg.htm (connection strings for
sql providers)


For SSMA:
http://www.microsoft.com/sql/solutions/migration/access/default.mspx

and see the newsgroup m.p.access.sqlupsizing.


For SSMSE:
http://www.microsoft.com/downloads/...FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796

 

[philip260]

Maybe a connection problem. First, you should try with SSMSE (Sql Server
Management Studio Express) to see if you can connect correctly. You can
also try using the SSMA for Access instead of the wizard to upgrade your
database.

Troubleshooting connection problem:

http://blogs.msdn.com/sqlexpress/ar...p://www.datamasker.com/SSE2005_NetworkCfg.htm (connection strings for
sql providers)

For SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx

and see the newsgroup m.p.access.sqlupsizing.

For SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.

What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.

thanks in advance for your help.- Hide quoted text -

- Show quoted text -

thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.

It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.

 

[Sylvain Lafontaine]

ADP doesn't have linked table but you should be OK with a MDB file and ODBC
linked tables agains SQL-Express.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

Maybe a connection problem. First, you should try with SSMSE (Sql Server
Management Studio Express) to see if you can connect correctly. You can
also try using the SSMA for Access instead of the wizard to upgrade your
database.

Troubleshooting connection problem:

http://blogs.msdn.com/sqlexpress/ar...p://www.datamasker.com/SSE2005_NetworkCfg.htm
(connection strings for
sql providers)

For
SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx

and see the newsgroup m.p.access.sqlupsizing.

For
SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.

What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.

thanks in advance for your help.- Hide quoted text -

- Show quoted text -

thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.

It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.

 

[philip260]

ADP doesn't have linked table but you should be OK with a MDB file and ODBC
linked tables agains SQL-Express.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

Maybe a connection problem. First, you should try with SSMSE (Sql Server
Management Studio Express) to see if you can connect correctly. You can
also try using the SSMA for Access instead of the wizard to upgrade your
database.
Troubleshooting connection problem:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp:/...
(connection strings for
sql providers)
For
SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx
and see the newsgroup m.p.access.sqlupsizing.
For
SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi go
to create new database option and click on trusted connection and when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does not
exist or access denied.
What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.
thanks in advance for your help.- Hide quoted text -
- Show quoted text -

thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.

It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.- Hide quoted text -

- Show quoted text -

I tried linking tables from my access database mdb through my sql
server odbc connection but the only tables that showed up seemed to
only be system tables? Can you help shed light on this problem?
THanks
Phil

 

[Sylvain Lafontaine]

System tables? I would say that you may have a permission problem or a
problem with the schemas (or owner for SQL-2000) of the tables. Using
anything else than dbo. as the schema (2005) or the owner (2000) of a table
is a good recipe to have problem with ODBC linked tables or ADP.

However, in your case, the first thing to check would be a permission
problem; so you should try using an account with full privileges on the
database, such as its owner or the « sa » account.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

ADP doesn't have linked table but you should be OK with a MDB file and
ODBC
linked tables agains SQL-Express.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

On Mar 7, 4:38 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Maybe a connection problem. First, you should try with SSMSE (Sql
Server
Management Studio Express) to see if you can connect correctly. You
can
also try using the SSMA for Access instead of the wizard to upgrade
your
database.

Troubleshooting connection problem:

http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp:/...
(connection strings for
sql providers)

and see the newsgroup m.p.access.sqlupsizing.

news:[email protected]...

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi
go
to create new database option and click on trusted connection and
when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does
not
exist or access denied.

What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.

thanks in advance for your help.- Hide quoted text -

- Show quoted text -

thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.

It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.- Hide quoted text -

- Show quoted text -

I tried linking tables from my access database mdb through my sql
server odbc connection but the only tables that showed up seemed to
only be system tables? Can you help shed light on this problem?
THanks
Phil

 

[philip260]

System tables? I would say that you may have a permission problem or a
problem with the schemas (or owner for SQL-2000) of the tables. Using
anything else than dbo. as the schema (2005) or the owner (2000) of a table
is a good recipe to have problem with ODBC linked tables or ADP.

However, in your case, the first thing to check would be a permission
problem; so you should try using an account with full privileges on the
database, such as its owner or the « sa » account.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

ADP doesn't have linked table but you should be OK with a MDB file and
ODBC
linked tables agains SQL-Express.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

On Mar 7, 4:38 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Maybe a connection problem. First, you should try with SSMSE (Sql
Server
Management Studio Express) to see if you can connect correctly. You
can
also try using the SSMA for Access instead of the wizard to upgrade
your
database.
Troubleshooting connection problem:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp:/...
(connection strings for
sql providers)
For
SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx
and see the newsgroup m.p.access.sqlupsizing.
For
SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing wizardi
go
to create new database option and click on trusted connection and
when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does
not
exist or access denied.
What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless and
dont know where to start.
thanks in advance for your help.- Hide quoted text -
- Show quoted text -
thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use it.
It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.- Hide quoted text -
- Show quoted text -

I tried linking tables from my access database mdb through my sql
server odbc connection but the only tables that showed up seemed to
only be system tables? Can you help shed light on this problem?
THanks
Phil- Hide quoted text -

- Show quoted text -

I think i figured it out. I changed my ODBC setting to point to my
database that i wanted to use. under DSN configuration there is a
checkbox for change the default database to and i selected the one i
wanted to use and not the master. now i am able to link to the tables
i have in my sql server express. Thanks for your help!
while im at it would you know how to link tables in sql server? =)

 

[Sylvain Lafontaine]

Linking table in sql-server? Not sure to understand the question but if you
are talking about creating linked servers on the SQL-Server, there is a
wizard in ADP under File | Get External Data | Linked tables that will
create for you a linked server with an associated view or an OPENQUERYSET
definition.

Use it and take a look at what this wizard will create under both Views and
Linked Servers.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

System tables? I would say that you may have a permission problem or a
problem with the schemas (or owner for SQL-2000) of the tables. Using
anything else than dbo. as the schema (2005) or the owner (2000) of a
table
is a good recipe to have problem with ODBC linked tables or ADP.

However, in your case, the first thing to check would be a permission
problem; so you should try using an account with full privileges on the
database, such as its owner or the « sa » account.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

ADP doesn't have linked table but you should be OK with a MDB file and
ODBC
linked tables agains SQL-Express.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

On Mar 7, 4:38 pm, "Sylvain Lafontaine" <sylvain aei ca (fill the
blanks, no spam please)> wrote:
Maybe a connection problem. First, you should try with SSMSE (Sql
Server
Management Studio Express) to see if you can connect correctly. You
can
also try using the SSMA for Access instead of the wizard to upgrade
your
database.
Troubleshooting connection problem:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspxhttp:/...
(connection strings for
sql providers)
For
SSMA:http://www.microsoft.com/sql/solutions/migration/access/default.mspx
and see the newsgroup m.p.access.sqlupsizing.
For
SSMSE:http://www.microsoft.com/downloads/details.aspx?displaylang=en&Family...
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)

hello all
im noobest ssme user here. I am trying to export my access backend
database into sql server express 2005 by using the upsizing
wizardi
go
to create new database option and click on trusted connection and
when
i hit next it gives me a microsoft sql server login error:
connection failed:
SQLState: '01000'
SQL Server Error: 2
[Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][Shared Memory]SQL Server does
not
exist or access denied.
What is causing this? Should i be doing something else like
configuring sql sever before upsizing. once again i am clueless
and
dont know where to start.
thanks in advance for your help.- Hide quoted text -
- Show quoted text -
thanks for the reply sylv
I downloaded SSMA but my work environment does not allow for the
registration file to be saved on my workstation so i could not use
it.
It was a connection error and I was able to connect when my odbc dsn
was setup correctly. the upsizing wizard is going right now as i
speak. Is there a way to connect to sql server express from a linked
table in an access frontend.- Hide quoted text -
- Show quoted text -

I tried linking tables from my access database mdb through my sql
server odbc connection but the only tables that showed up seemed to
only be system tables? Can you help shed light on this problem?
THanks
Phil- Hide quoted text -

- Show quoted text -

I think i figured it out. I changed my ODBC setting to point to my
database that i wanted to use. under DSN configuration there is a
checkbox for change the default database to and i selected the one i
wanted to use and not the master. now i am able to link to the tables
i have in my sql server express. Thanks for your help!
while im at it would you know how to link tables in sql server? =)