[JMeter connection to SQLServer] connection using window authentication (original)

As we all know, Jmeter can be used to connect to various databases. If you still don't know how to connect to Jmeter, refer to another blog article I 've read, here is a detailed description of the blog. csdn. netlzqinfenarticledetails38730259 is back to the question. Due to problems in the company's test environment, when I connect to SQLServer,

As we all know, Jmeter can be used to connect to various databases. If you still don't know how to connect to Jmeter, refer to another blog article I 've read, here I have a detailed introduction to the http://blog.csdn.net/lzqinfen/article/details/38730259 regression problem, due to the company's test environment problems, when I connect to SQLServer,

As we all know, Jmeter can be used to connect to various databases. If you still don't know how to connect to Jmeter, please refer to another blog article I have read. Here is a detailed introduction.

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

Back to the question, due to the test environment of the company, when I connect to SQLServer, the company can only use window authentication (through our domain account verification), which becomes troublesome, because the General SQL server connection is as simple as the following:

However, the window authentication method is used. You cannot enter username and password. I want to query through the Internet, including the performance technology group, and I have not found any related solutions. After trying all kinds of solutions, I finally got it done ~ (So I think it is an original method, so it should not be too much)

1. Connect to the database using Java

Jmeter is pure Java. Everyone knows that when writing Java, you can write windows to connect to SQLserver. Therefore, I firmly believe that Jmeter can be implemented in the same way. Java is actually adding a parameter

IntegratedSecurity = true

Therefore, we also make modifications in JMeter, such as (the front is IP address and port. IntegratedSecurity = true is added later. Note: The database name is not specified here. You can specify it or not)

2. It seems that there is no problem. Run the command and an error is returned (an error is reported in the Jmeter command window ),

Error: driver not configured for integrated Authentication

The reason is that the sqljdbc_auth.dll file is missing in C: \ Windows.

3. DownloadRun sqljdbc_auth.dll in C: \ Windows, restart, and run OK again.

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

----------------------------------Note: minefield---------------------------------------------

1. sqljdbc_auth.dll has been stored in the relevant directory, but an error such as 64-bit is reported.

The reason is: I use win7 64-bit. The downloaded sqljdbc_auth package contains x86 and 64-bit (three versions each). I found the 64-bit package, an error is also reported if you use it. Then, you can select the dll on the latest date (3.0.1301.101 ).

(My Jmeter version is 2.8 + 1.7JDK, and the latest dll for Jmeter2.11 should be okay. Please verify it ~);

2, another point of attention: Jmeter apache-jmeter-2.8 \ lib should have sqljdbc4.jar, if not, it will certainly report an error.