SQL Migration Assistant for Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using the above MS tool -- and I can't get this assistant to connect to
my existing sql server database? Can you point to some help for this?
Thanks.
 
If there is someone administrating the SQL Server/network, you should ask
him/her for the information needed to connect to an SQL Server database.
Basically, if the SQL server uses Windows security, you need to know the SQL
Server instance name (if it is default instance, that will be the computer
name where the SQL Server installed), and the database name. If the SQL
Server is configured to allow remote access and your windows user account
has the permission to access the SQL Server/database, then you should not
have difficutyies to follow the Migration assistnace. If the SQL Server uses
mixed secuirty mode, you can, instead, ask a username/password pair from the
administrator.

OTH, since you are to migrate your Access database to SQL Server database,
it is strongly recommended to do your due study on SQL Server before
migrating, after all, SQL Server is a very complicated server software
package.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top