This looks useful, but would be easier to find on the Wiki, if you don't mind putting it there?
On 14 January 2014 15:26, KIRAN <[email protected]> wrote: > 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 >
