title: JMeter SQLServer Database Load test
body: <p>I am trying to set up a basic load test using Jmeter against SQLServer 2008 R2 database. However, I am getting an error when running the test with just one user.</p>
  
  <p>Response message: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user XXX. ClientConnectionId:.</p>
  
  <p>Here are my JDBC Connection configurations
  Database URL: jdbc:sqlserver://Servername:1433;DatabaseName=XXX_DB;
  JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver</p>
  
  <p>I have tried few things but had no luck.</p>
  
  <p>-Downloaded and installed the jdbc driver - sqljdbc4.jar
  - Changed the security mode to mixed in SQL server management studio
  - Added the directory paths of the jdbc driver in testplan</p>
  
  <p>Tried a couple of other things but had no luck. Please provide some suggestions to resolve the issue. Looking forward for help.</p>
  
  <p>Cheers,
  Deshdeep.</p>