# Logstash ms sql connector

**URL:** <https://discuss.elastic.co/t/logstash-ms-sql-connector/118806>\
**Category:** Logstash\
**Created:** [February 7, 2018, 10:29am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806 "2018-02-07T10:29:50Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Anuar\_Mukatov](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Anuar\_Mukatov](https://discuss.elastic.co/u/Anuar_Mukatov)\
**Post date:** [February 7, 2018, 10:29am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806/1 "2018-02-07T10:29:50Z")

</div>

Hello!  
I have some trouble with jdbc input plugin. How i can connect to ms sql database with windows domain authentication?  
I know how connect with sql login name, but i can't understand how to connect with domain username?

My config file -

```
input {
jdbc {
jdbc_driver_library => "/etc/logstash/drivers/enu/jre8/sqljdbc42.jar"
jdbc_driver_class => "com.microsoft.sqlserver.jdbc.SQLServerDriver"
jdbc_connection_string => "jdbc:jtds:sqlserver://server:1433;databasename=2008"
jdbc_user => "login"
jdbc_password => "pass"
statement => "SELECT m.*
, mc.nameRu AS CategoryNameRu
, mt.nameRu AS TypeNameRu
, ms.nameRu AS SourceNameRu
, p.Fio_Ru
, s.RowName AS LoginName
, pos.FullNameRu AS PositionNameRu
FROM LOG_Messages m
JOIN DIC_LOG_MESSAGE_SOURCE_TO_TYPE mst ON mst.id = m.refMessageSourceType
JOIN DIC_LOG_MESSAGE_CATEGORY mc ON mc.id = mst.refMessageCategory
JOIN DIC_LOG_MESSAGE_TYPE mt ON mt.id = mst.refMessageType
JOIN DIC_LOG_MESSAGE_SOURCE ms ON ms.id = mst.refMessageSource
LEFT JOIN ULS_Persons p ON p.id = m.refRecordCard
LEFT JOIN LOG_SidIdentification s ON s.id = m.refSid
LEFT JOIN ULS_SubdivisionPositions pos ON pos.id = m.refPosition
where datetime > :sql_last_value"
use_column_value => "true"
tracking_column => "datetime"
}
```

---

<div class="post-metadata">

**Author:** ![Anuar\_Mukatov](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Anuar\_Mukatov](https://discuss.elastic.co/u/Anuar_Mukatov)\
**Post date:** [February 7, 2018, 11:26am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806/2 "2018-02-07T11:26:28Z")

</div>

Where are you guru of logstash? =)

---

<div class="post-metadata">

**Author:** ![Anuar\_Mukatov](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Anuar\_Mukatov](https://discuss.elastic.co/u/Anuar_Mukatov)\
**Post date:** [February 8, 2018, 2:31am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806/3 "2018-02-08T02:31:45Z")

</div>

Anyone?

---

<div class="post-metadata">

**Author:** ![Anuar\_Mukatov](https://avatars.discourse-cdn.com/v4/letter/a/dec6dc/32.png) [@Anuar\_Mukatov](https://discuss.elastic.co/u/Anuar_Mukatov)\
**Post date:** [February 8, 2018, 4:18am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806/4 "2018-02-08T04:18:35Z")

</div>

I found my problem solution =)

```
 jdbc_driver_library => "/etc/logstash/drivers/jtds-1-2/jtds-1.3.1.jar"
 jdbc_driver_class => "Java::net.sourceforge.jtds.jdbc.Driver"
 jdbc_connection_string => "jdbc:jtds:sqlserver://server:1433;domain=NAME;integratedsecurity=true;databasename=2008"
 jdbc_user => "login"
 jdbc_password => "pass"
```

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [March 8, 2018, 4:18am UTC](https://discuss.elastic.co/t/logstash-ms-sql-connector/118806/5 "2018-03-08T04:18:37Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.