Configure remote database access

For inter-team development, you need to use the same database server. Therefore, you must use IP addresses to access the database.

There are three methods to access the database.

1,

Access the local database directly. Enter "." In the server name.

2,

Access the local database directly. Enter the local database name in the server name.

3,

For local or remote access, enter the IP address of the computer where the sqlserver database is located in the server name. However, some configurations are required.

The configuration steps are as follows:

① Configure an IP address for a computer with sqlserver

② Close the firewall: Control Panel → Firewall

③ Enable sqlserver configuration management tool

After opening, set the project (TCP/IP and named pipes) in the figure to the startup status.

Double-click TCP/IP to configure the IP address

④ Allow remote access on sqlserver: Right-click SA and select Properties

⑤ Set the Verification Method

Right-click database instance → click Properties → click Security

Set it to sqlserver and Windows authentication.