New SQL Server Connection
Create a New SQL Server Connection
The tool supports both Windows authentication and SQL Server authentication. The method of filling in the information differs between the two. You can refer to SQL Server Management Studio or Navicat for database connection details.
Server Name: You can enter the computer's hostname, localhost, 127.0.0.1, or the computer's IP address.
Username: Defaults to the computer's hostname\username when logged in.
Password: Leave blank by default.
Database: Enter the name of the database you want to import into.
Schema: The default schema is dbo. If you want to import into a different schema, enter its name.
SQL Server Management Studio with Windows Authentication is depicted in the following image:
Step 1: Click "Test Connection" directly.
Step 2: Select the database and schema you want to import data into, fill in the connection name, and click "OK".
To connect using SQL Server Authentication, ensure that mixed mode authentication is specified during the database installation; otherwise, the connection will fail.
Server: Enter the server address where the SQL Server database is installed. For a local database connection, you can enter the computer's hostname, localhost, 127.0.0.1, or your computer's IP address. For a remote database connection, enter the server's IP address.
Username: Enter the username that is allowed to connect to the SQL Server database and has the necessary permissions to use the tool (e.g., for CRUD operations).
Password: Enter the corresponding password for the username provided. If the connection fails, double-check that the password is correct.
Database: Enter the name of the database you want to connect to.
Schema: The default schema is dbo. If you want to connect to a different schema, enter its name.
SQL Server Management Studio with SQL Server Authentication is depicted in the following image:
Step 1: Choose SQL Server Authentication for authentication, enter the connection information, and click "Test Connection".
Step 2: Select the database and schema you want to connect to, enter the connection name, and click "OK".
ODBC Driver: In the advanced options interface under ODBC Driver, the installed ODBC drivers on your computer are listed. The tool automatically selects the highest version for connection. If this option is empty, it means there are no available ODBC drivers on your computer, and you need to install them before connecting. If the ODBC driver version is too low, it might also cause connection issues. Download and install the latest ODBC driver and then restart the tool to try again. Download Microsoft ODBC Driver 18 for SQL Server (x64)