Sam
You're welcome. Maybe you can use the IP address instead of the SQL Server name.
Bill
--- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@...> wrote:
>
> 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