Java Hibernate sql server express connection error

Question

Trying to connect my Java Spring app on Tomcat to my sqlserver express database with Hibernate.

Getting error:

com.microsoft.sqlserver.jdbc.SQLServerException: Connection Failed TCP / IP to localhost port 1433.
Error: "Connection refused: connect. Check the connection properties, make
sure that an instance of SQL Server is running on the host and accepting TCP
/ IP connections to port, and make sure that no firewall is blocking TCP 
connections to port. ".

may be you get the answer from here Visit stackoverflow.com/questions/18841744/… — Zubair Nabi
– Zubair Nabi, Commented Feb 9, 2016 at 9:09
i go to Enable TCP/IP Right box and i found it already Enable TCP/IP 1433 — Nabil Harboul
– Nabil Harboul, Commented Feb 9, 2016 at 9:14

Hamza Toussi · Accepted Answer · 2016-03-04 15:36:43Z

1

the problem is that your tcp/ip protocol is not 1433, please follow theses instructions and your problem should be gone : SqlServer Configuration Manager > Sql server Network configurations > protocols for SQLEXPRESS > right click on TCP/IP > properties > IP Adress > IPALL and change TCP PORT to 1433

answered Mar 4, 2016 at 15:36

Hamza Toussi

10810 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Zubair Nabi · Accepted Answer · 2016-02-09 09:39:59Z

0

in majority of cases its the firewall that blocks it. try disabling it

answered Feb 9, 2016 at 9:39

Zubair Nabi

1,0568 silver badges29 bronze badges

Collectives™ on Stack Overflow

Java Hibernate sql server express connection error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related