You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@jmeter.apache.org by KIRAN <rk...@gmail.com> on 2014/01/14 16:26:54 UTC
To add jMeter the support to run sql queries using windows authentication
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
Re: To add jMeter the support to run sql queries using windows authentication
Posted by sebb <se...@gmail.com>.
The Wiki is at
https://wiki.apache.org/jmeter/
You will need to create a login and then e-mail the dev@ list so it
can be added to the list of allowed contributors.
Then just add the information in a new page, and link it somewhere relevant
On 14 January 2014 16:23, KIRAN <rk...@gmail.com> wrote:
> 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 <se...@gmail.com> 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 <rk...@gmail.com> 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
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@jmeter.apache.org
For additional commands, e-mail: user-help@jmeter.apache.org
Re: To add jMeter the support to run sql queries using windows authentication
Posted by KIRAN <rk...@gmail.com>.
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 <se...@gmail.com> 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 <rk...@gmail.com> 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
Re: To add jMeter the support to run sql queries using windows authentication
Posted by sebb <se...@gmail.com>.
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 <rk...@gmail.com> 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
>