CODEWITHSUNDEEP
sqlsql-serverjmeter
Vladimir Krygin
Vladimir Krygin

Reputation: 645

Jmeter can't connect to local ms sql server

I need to connect Jmeter to my local MS SQL Server database. Everything works fine, when I'm working with remote databases, but when it comes to local databeses I get stuck at the beginning.

I've tried these settings to connect to my DB:

Database URL: jdbc:sqlserver://DESKTOP-IEK3G1S\SQLEXPRESS;DatabaseName=TestBase
JDBC Driver class :  com.mircrosoft.sqlserver.jdbc.SQLServerDriver

And this is what i get:

Response message: java.sql.SQLException: 
Cannot create PoolableConnectionFactory (The connection to the host DESKTOP-IEK3G1S, named instance sqlexpress has failed. 
Error: "java.net.SocketTimeoutException: 
Receive timed out". Verify the server and instance names, check that no firewall is blocking UDP traffic to port 1434, and for SQL Server 2005 or later verify that the SQL Server Browser Service is running on the host.)```

Upvotes: 0

Views: 1558

Answers (2)

Dmitri T
Dmitri T

Reputation: 168197

  1. Enable TCP/IP in the SQL server configuration:

    enter image description here

  2. Enable IP address and set the desired TCP port for the connection:

    enter image description here

  3. SQL Server default TCP port is 1433, most probably you should be using 1433 in your JDBC Connection Configuration setup

  4. Enable SQL Server Authentication mode or add Integrated Security = true to your JDBC URL if you plan to connect with your current credentials (you will need to have sqljdbc_auth.dll file under Java Library Path)
  5. Make sure to use matching SQL Server JDBC Driver
  6. Change "Validation Query" to be select 1

Upvotes: 0

Vladimir Krygin
Vladimir Krygin

Reputation: 645

Well, I had to recreate my SQL Browser connection and manually shutdown everything that was turned on in my Firewall options and everything has started working.

Upvotes: 1

Related Questions