Home > Documentation >
MS Access to SQL Server > Tutorial
Step 2 of 5. Connect to SQL Server
If "Migrate to MS SQL server directly" option has been selected on
the first page, the user is required to enter necessary settings for
connection with the server. In "MS SQL Server" field the name of
MS SQL Server instance must be specified. Leave it empty if connecting to
the local server. Custom MS SQL port (other than 1433) can also be specified in
"MS SQL Server" field as follows:
where 1234 is the custom port. Then select the type of authentication to use
when connecting to SQL Server:
- Windows authentication - SQL Server validates the connection via
Windows user information. The user has to be authenticated by Windows before
access is granted.
- SQL Server authentication - SQL Server will use the standard security
validation. To use this option, specify user name and password recognized on
the target MS SQL Server.
If connection to MS SQL failed, read How
to configure SQL Server article for possible workaround.
Have questions? Contact us