Li Lan-myeclispe connecting to a SQL Server database

The first step, in terms of SQL Server

Here is the login with authentication.

Here I have built a HW database, and nothing else to say.

The second step, the main part

Because the SQL Server database is connected for the first time, you do not know this step. This will cause the following error to occur.

Com.microsoft.sqlserver.jdbc.SQLServerException: TCP/IP connection to host failed

The solution is as follows: first check whether the status of TCP/IP is enabled, if it is disabled, right click the TCP/IP option, select Enable, then view its properties, select the IP address, pull to the bottom, you can see the ipall,tcp port filled in 1433, click OK.

Then select the client protocol under the SQL Navite 10.0 configuration, where the status of TCP/IP is guaranteed to be enabled.

Finally, to restart the service to ensure that the changes take effect, select SQL Server under SQL Server service, right-click the restart

In terms of Myeclispe, the connection is roughly the same.

Li Lan-myeclispe connecting to a SQL Server database