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:
 
Sql_server_name,1234
 
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