title: How to connect JDBC to Microsoft SQL Server in JMeter?
body: <p>How to connect JDBC to Microsoft SQL Server so that I can test my SQL Server database in JMeter. </p>
  
  <p>I am using Apache Jmeter 2.13. I have put the sqljdbc4.jar file in JMeter/lib folder. I also created a very simple database in Microsoft SQL Server Management Studio where my server name is localhost and I have used windows authentication to connect to my server. Then in JMeter I have used the following properties in JDBC Connection Configuration :</p>
  
  <pre><code>Database URL:jdbc:sqlserver://localhost:1433;DatabaseName=JmeterTestDatabase.
  JDBC Driver Class:com.microsoft.sqlserver.jdbc.SQLServerDriver.
  Username:ABC-PC\ABC.
  Password: Somepassword.
  </code></pre>
  
  <p>When I run the test I get the following error:</p>
  
  <blockquote>
    <p>com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user
    'ABC-PC\ABC'. ClientConnectionId:7c9e308b-1bdc-4513-8386-5bc51f249029</p>
  </blockquote>
  
  <p>What is going wrong here? </p>