Thought of sharing some information regarding MS SQL DB connectivity with JMeter:
1. Download dlls from the below link: http://msdn.microsoft.com/en-us/sqlserver/aa937724.aspx [image: Inline image 1] 2. The below file will get downloaded [image: Inline image 2] 3. Unzip/install it and you can see the dlls. Copy the folder ‘Microsoft JDBC Driver 4.0 for SQL’ to C drive. 4. Copy the highlighted dll in the path “C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu” to lib folder of jMeter. [image: Inline image 3] 5. To enable windows authentication add “C:\Microsoft JDBC Driver 4.0 for SQL Server\sqljdbc_4.0\enu\auth\x64” to the environment variable ‘Path’ 6. Database Connection Configuration in jMeter should look like: *Database URL:* jdbc:sqlserver://<DB IP address:Port Number>;DatabaseName=<DB Name>;integratedSecurity=true; *JDBC Driver class:* com.microsoft.sqlserver.jdbc.SQLServerDriver *Username:* leave it blank *Password:* leave it blank Please correct me if any errors. -- Regards, Kiran
