Re: Upsizing wizard access Sql Server express

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://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspxhttp://msdn2.microsoft.com/en-us/library/ms345318.aspxhttp://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)

<philip...@xxxxxxxxx> wrote in message

news:1173302581.030205.174210@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



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.

.

Relevant Pages

  • Re: Upsizing wizard access Sql Server express
    ... Sylvain Lafontaine, ing. ... Troubleshooting connection problem: ... database into sql server express 2005 by using the upsizing wizardi go ... SQL Server Error: 2 ...
    (microsoft.public.access.adp.sqlserver)
  • Connection failed SQL State 01000 SQL error 52
    ... Connection failed ... SQL Server Error: 52 ... I have tried SQL Server authentication, ...
    (microsoft.public.project)
  • ODBC Connection.
    ... There is a problem with my ODBC connection. ... a connection time out occurs and the error ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • ODBC Connect Prob in 2005
    ... Connection Failed: ... SQLState: '08001' ... SQL Server Error: 1326 ... SQL Server Error: 0 ...
    (microsoft.public.sqlserver.odbc)
  • Re: Error "SQL Server does not allow remote connections"
    ... The application could not connect to the sql server db. ... network is blocking the connection. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 ... integratedSecurity, SqlConnection owningObject) +737554 ...
    (microsoft.public.dotnet.framework.aspnet)