As I am new to JMeter protal, could someone please guide me on how to add this information to JMeter wiki?
On Tue, Jan 14, 2014 at 11:13 AM, sebb <[email protected]> wrote: > 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 > > > -- Regards, Kiran
