Com. microsoft. sqlserver. jdbc. SQLServerException

Source: Internet
Author: User
Com. microsoft. sqlserver. jdbc. SQLServerException: connection to the TCPIP of the host localhost through port 1433 fails. Error: Connectionrefused: connect. Verify the Connection Properties, check that the SQLServer instance is running on the host, accept the TCPIP connection on this port, and make sure that the firewall does not

Com. microsoft. sqlserver. jdbc. SQLServerException: The TCP/IP connection to the host localhost through port 1433 fails. Error: Connection refused: connect. Verify the Connection Properties, check that the SQL Server instance is running on the host, accept the TCP/IP connection on this port, and make sure that the firewall does not

Com. microsoft. sqlserver. jdbc. SQLServerException: The TCP/IP connection to the host localhost through port 1433 fails. Error: "Connection refused: connect. Verify the Connection Properties and check that the SQL Server instance is running on the host. The U.S. Server accepts TCP/IP connections on this port, make sure that the firewall does not block the TCP connection to this port. ".
Why does hibernate link to SQL Server2008 and my solution?

Com. microsoft. sqlserver. jdbc. SQLServerDriver
Jdbc: sqlserver: // localhost: 1433; databaseName = spring
Sa
Gaoweigang

Sqljdbc4.jar needs to be introduced in the project

Cause: 1. It may be that the SQL Server is not started.

2. SQL Server network configuration TCP/IP is not enabled

3. Check whether the default port number of TCP/IP is 1433 in the client protocol.

Solution: Open SQL server configuration manager

1. Check whether the default port number of TCP/IP is 1433 in the client protocol and ensure that the port is enabled.

2. Start the SQL Server network configuration/MSSQLSERVERd protocol/TCP/IP

3. Restart the SQL Server service/SQL Server (MSSQLSERVER) Server

After the above steps, the problem can be solved.

, Hong Kong server rent

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.