Connect to SQL Server

dbForge Data Compare for SQL Server allows a user to establish a connection between a database and a server using the Database Connection Properties dialog.

To open the Database Connection Properties dialog, navigate to the Database main menu and select New Connection.

General connection settings

The following table displays the connection settings you need to specify to connect to the SQL Server:

Setting Description
Server Name of the server you want to connect.
Authentication The list of available authentication modes:
Windows Authentication
SQL Server Authentication
Active Directory - Universal with MFA authentication
Azure Active Directory - Password
Azure Active Directory - Integrated.
For more information about how to connect to a database with the Azure Active Directory authentication, refer to Connect with Azure Interactive Authentication.
Login Login of your MySQL server user account.
Password Password for the specified user.
Allow saving password When it is selected (default state), the password you enter will be saved for later use. To cancel the password saving, clear the checkbox.
Database Choose a database you want to connect.
Connection Name Name of the server you connect. By default, it uses the Host name. To display a different name, enter it here.
This setting is optional.
Environment Category The default option is *None**. To set a connection category, select one from the following options: Development, Production, Sandbox, or Testing.

Note

To connect to a SQL Server using a custom port, specify the server name followed by a comma and the custom port number. For example, localhost,62005.

Optional: To verify the connection settings, click Test Connection.

Successfully connected

Click Connect to create the connection.

Note

If you set up a connection in one of the following tools, it will be automatically added to other dbForge SQL Tools:

You can migrate connections and assigned categories between dbForge SQL tools (for example, from dbForge Data Compare for SQL Server to dbForge Data Generator for SQL Server). To do that, you should create an export settings file with the help of Import and Export Settings Wizard in one tool and then import it in another dbForge SQL tool. For more information, see Import and export settings.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Data Compare for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the Data Compare in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Data Compare for your business, request a demo to see it in action.
Ready to start using dbForge Data Compare for SQL Server?