Sorry for all the questions. I need to send the connection string with the password for this db to another developer and I'm wondering if it's standard practice to email it? I'm a little bit paranoid about stuff like that.
--- In MS_Access_Professionals@yahoogroups.com, "sarmbraugh" <sarmbraugh@...> wrote:
>
> 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