Eclipse Community Forums: Newcomers » Cannot connect to SQLServer from eclipse

Help

Home

Home » Newcomers » Newcomers » Cannot connect to SQLServer from eclipse

Show: Today's Messages :: Show Polls :: Message Navigator

Cannot connect to SQLServer from eclipse [message #1799524]

Sat, 08 December 2018 11:44

Poh Kai

Messages: 1
Registered: December 2018

Junior Member

I have a dynamic web project in eclipse and i tried to add JPA to the project. Here are my steps to add JPA:

(1) I right click on my project, then click properties, then i searched "Project Facets" and selected the JPA checkbox and then clicked "Further configuration required"
(2) On the "Modify Faceted Project" modal, I clicked "Add connection..."
(3) On the "New Connection Profile" modal, I clicked "SQL Server", then clicked "Next"
(4) I chose "Microsoft SQL Server 2008 JDBC Driver" and set port number to 3306 and username to root and password to root
(5) Then I clicked "Test Connection", then i got this error:

com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host localhost, port 3306 has failed. Error: "The driver received an unexpected pre-login response. Verify the connection properties and check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. This driver can be used only with SQL Server 2000 or later.". ClientConnectionId:5b776a70-6b5d-47eb-b995-19311ebda537

I check that I was able to connect to my local SQL database using MySQLWorkbench with the same username and password.

Can anyone help me please?

Report message to a moderator

Re: Cannot connect to SQLServer from eclipse [message #1799804 is a reply to message #1799524]

Thu, 13 December 2018 19:08

Patrick Moran

Messages: 141
Registered: March 2018

Senior Member

Have you tried with any other external DB sites that permit free access? It would really help if you could capture the stream of information going out to the Microsoft DB site.

Report message to a moderator