You can create a database connection using the Database Connection Properties dialog.
To create a connection:
1. Open the Database Connection Properties dialog by doing one of the following:
On the Database menu, select New Connection.
On the Database Explorer toolbar, click New Connection.
In Database Explorer, right-click any connection and select New Connection.
Right-click anywhere in Database Explorer and select New Connection.
2. On the Database Connection Properties > General tab, set up general connection parameters:
2.1. In the Server list, specify the server name or choose the server:
Tip
Select Refresh to scan your network for available SQL Server instances. If any are found, they appear under Network in the Server list. This option helps you quickly identify and connect to accessible database servers within your local network.
2.2. In the Authentication list, choose the authentication mode:
For instructions, see How to connect with Microsoft Entra ID authentication.
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
.
2.3. In the Login and Password boxes, enter the user credential details, respectively. By default, the password is saved automatically.
To cancel saving the password, clear the Allow saving password checkbox.
2.4. In the Database box, enter the name of a SQL database you want to connect to or select the database from the list.
By default, the Show all databases checkbox is selected.
To hide all databases available for the connection in Database Explorer, clear the checkbox.
2.5. Optional: In the Connection Name box, the connection name is generated automatically from the server name. To specify a different name, enter it here.
2.6. Optional: From the Environment Category list, choose the document category, such as Development, Production, Sandbox, and Test.
To create a new environment category, select Browse in the Environment Category list. For instructions about customizing environment categories, see Window connection coloring.
3. Optional: On the Database Connection Properties > Advanced tab, configure advanced connection properties:
4. Optional: To verify the connection, select Test Connection.
4.1. The window with the message informing about a successful connection appears. Select OK to close the window.
5. To create the connection, select Connect.
You can also watch this video to learn how to connect to a SQL Server database in dbForge Studio for SQL Server.