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";Persist Security Info=True;User ID=SomeUser;Initial Catalog=BLAH_STUFF;Data Source=blah-blah-blah.whatever.com
--- In MS_Access_Professionals@yahoogroups.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, "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.
> >
>
Tidak ada komentar:
Posting Komentar