Thanks, Bill. I'm Sam.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> [Your name?]
>
>
>
> It sounds like this is not a regular upsizing within a local network. I don't
> think you can use a .com name for an SQL Server name. Try doing the upsizing
> locally and then uploading the database to whatever host you have.
>
>
>
> Regards,
>
> Bill
>
>
>
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of sarmbraugh
> Sent: Wednesday, June 27, 2012 1:53 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] Re: SSMA for Access
>
>
>
>
>
> Thanks for your reply, Bill.
>
> In the "Connect to SQL Server" wizard:
> Server name: blah-blah-blah.whatever.com
> Server port: [default]
> Database: BLAH_STUFF
> Authentication: SQL Server Authentication
> User name: SomeUser
> Password: LongStringContainingNonAlphanumericCharacters
>
> Tried connecting with "Encrypt Connection" and "Trust Server Certificate"
> checked and unchecked
>
> Not sure if this is of any use, but I have a working connection string that I
> copied from a .udl file, and am wondering if I could try that with SSMA somehow.
> The connection string looks like:
>
> Provider=SQLOLEDB.1;Password="LongStringContainingNonAlphanumericCharacters";Per
> sist Security Info=True;User ID=SomeUser;Initial Catalog=BLAH_STUFF;Data
> Source=blah-blah-blah.whatever.com
>
> --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "Bill Mosca" <wrmosca@>
> wrote:
> >
> > Hmmm...I've never run up against that error. Check your spelling of the SQL
> Server instance. Be sure to include the entire name. Also, be sure you are not
> including the file extension in the database name.
> >
> > If you are still stuck post examples of the entries you are using (don't use
> the real names).
> >
> > Regards,
> > Bill Mosca, Founder - MS_Access_Professionals
> > http://www.thatlldoit.com
> > Microsoft Office Access MVP
> > https://mvp.support.microsoft.com/profile/Bill.Mosca
> >
> >
> >
> > --- In MS_Access_Professionals@yahoogroups.com
> <mailto:MS_Access_Professionals%40yahoogroups.com> , "sarmbraugh" <sarmbraugh@>
> wrote:
> > >
> > > Hello,
> > >
> > > I'm trying to run SQL Server Migration Assistant to migrate tables from
> Access 2010 to SQL Server Express 2005. I can link to the SQL Server database
> with an Access data project using the server name, database name, login name and
> password that I have been given, but when I try to connect to SQL Server through
> SSMA using the same information, I get this message:
> > > "Connection to SQL Server failed. Format of the initialization string does
> not conform to specification starting at index 90."
> > >
> > > I'm new to this. Any thoughts are appreciated -- thanks.
> > >
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar