"JMeter connection to SQL Server" is connected using the Window authentication Method (original)

We all know that jmeter can connect a variety of databases, this aspect I do not say much, if you do not know how to connect, you can see the other blog I read, here is a detailed introduction

http://blog.csdn.net/lzqinfen/article/details/38730259

Back to the point, due to the company's testing environment, I connect SQL Server, the company can only use the window authentication (through our domain account verification), this becomes troublesome, because it would have been in accordance with the normal SQL Server connection, is very simple as the same:

But now using the Window authentication method, you can no longer fill in username and password. I would like to search through the Internet, including performance technology group, have not found the relevant solutions, and then all kinds of attempts to finally fix ~ (so I think it is the original method, should not be too)

1. Java Connection Database

JMeter is pure Java, we all know that when they write Java, can be written as a window way to connect to SQL Server, so I firmly believe that jmeter should be able to use the same method to achieve. Java implementation, in fact, adds a parameter

integratedsecurity= true

So we also make changes in the JMeter, such as (front is IP and port. Added integratedsecurity= true, note : My side does not specify the database name, you can specify or do not specify)

2, seemingly no problem, run, results error (jmeter Command window error),

Error: No driver configured for integrated authentication

The reason is: sqljdbc_auth.dll file is missing under C:\Windows

3. Download Sqljdbc_auth.dll, and put it under C:\Windows, reboot, run OK again.

: http://download.csdn.net/detail/lzqinfen/8066775

---------------------------------- Note: mined area ---------------------------------------------

1,Sqljdbc_auth.dll has been placed in the relevant directory, but the report is not 64-bit errors.

The reason is: My is Win7 64-bit, download the Sqljdbc_auth package contains x86 and 64 bits (each 3 version), I found 64 of them, a random one is an error, and then select the latest date (3.0.1301.101 this) that DLL That's OK, everybody.

(I jmeter is 2.8 +1.7jdk, Jmeter2.11 version of the latest DLL should also be no problem, please verify it ~);

2, another point of attention: Jmeter Apache-jmeter-2.8\lib under should have Sqljdbc4.jar , if not, will certainly also error.

"JMeter connection to SQL Server" is connected using the Window authentication Method (original)