JDBC connection issue

Question

I am trying to connect to my local sqlserver instance with the JDBC driver from the Visual Studio IDE. When I try to connect with the URL: "jdbc:sqlserver://localhost:1433;databaseName=master;user=sa;password=xxxx" , I get the error message: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host OCLPF2H20JA, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". Since I am not going through any firewalls I am a bit lost as to what the issue is. Is there a SqlServer setting I am missing to allow that kind of traffic, or is this a JDBC issue of some kind?

Answer 1

Hi WylieRobert-4759,

Welcome to Microsoft Q&A.

Please go to check the following things:

• Make sure the SQL Server instance is running.
• Please go to SQL Server Configuration Manager -> expand SQL Server Network Configuration->Protocols for InstanceName, make sure TCP/IP is enabled.

• Then go to TCP/IP properties-> IP Addresses tab, make sure SQL Server instance is listening on port 1433 under TCP port.
• Please make sure you have configured the firewall on the computer running SQL Server to allow access. Please refer to this doc which might help.

Best Regards,
Amelia

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Can you connect to SQL Server using SSMS or SqlCmd with same parameter?
Are you may using a SQL Server Express Edition as named instance? That one don't use port 1433 by default, but an other one.

Answer 3

I was able to get by the connection issue, but now I am getting the following error: An attempt to login using SQL authentication failed. Server is configured for Integrated authentication only". I have checked both servers and they are setup for both Windows and SQL.

Answer 4

Hi WylieRobert-4759,
Thanks for your reply.
This error may be caused by SQL Server configured for Windows authentication only.
You can use the follow query to check the SQL Server Authentication Mode:

SELECT CASE SERVERPROPERTY('IsIntegratedSecurityOnly')     
WHEN 1 THEN 'Windows Authentication'     
WHEN 0 THEN ' SQL Server and Windows Authentication'     
END as [Authentication Mode]    

If the result is Windows Authentication, please go to SSMS, right-click the server, and then click Properties-> Security page, then select SQL Server and Windows Authentication instead.

Best Regards,
Amelia

Answer 5

Amelia,
Thank you for the suggestion, but I have had the SQL Server and Windows Authentication Mode turned on and still get the same error.