[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