Home > Documentation > MS SQL to MySQL > Tutorial

Step 2 of 7. Connect to SQL Server

On this screen SQL Server to MySQL converter allows to provide necessary information for connection to MS SQL or Azure SQL. In "MS SQL Server" field the name of MS SQL instance must be specified. Leave it empty if connecting to the local server. Custom SQL Server 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.

In "SQL Server authentication" mode MS SQL to MySQL converter shows database tables owned by the specified user only. You can change it using "Connect as database owner" checkbox. It will force the program to display all tables from "dbo" tablespace, but only if the specified user has enough privileges to read them. Otherwise, the option will not take effect.

If connection to MS SQL failed, read How to configure SQL Server article for possible workaround.

If you are connecting to Azure SQL, see How to connect to Windows Azure SQL article for related information.

Have questions? Contact us