# JDBC want to connect to db as windows user

**URL:** <https://discuss.elastic.co/t/jdbc-want-to-connect-to-db-as-windows-user/209628>\
**Category:** Logstash\
**Created:** [November 27, 2019, 7:57am UTC](https://discuss.elastic.co/t/jdbc-want-to-connect-to-db-as-windows-user/209628 "2019-11-27T07:57:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![kolten](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/kolten/32/35725_2.png) [@kolten](https://discuss.elastic.co/u/kolten)\
**Post date:** [November 27, 2019, 7:57am UTC](https://discuss.elastic.co/t/jdbc-want-to-connect-to-db-as-windows-user/209628/1 "2019-11-27T07:57:05Z")

</div>

I want to read db with jdbc input.

Logstash wants to connect with windows authentication but i dont want this. Because windows authentication is not permitted. But logstash do this and crashes.

How can i solve this problem?

```
Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Login failed for user 'TEST-DB\sgslogdb'.

```

My Conf:

> input {  
> jdbc {  
> jdbc\_connection\_string =\> "jdbc:sqlserver://127.0.0.1:1433;instanceName=TEST-DB,databaseName=db\_log;integratedSecurity=true;"  
> jdbc\_driver\_library =\> "C:\sqljdbc\_4.2\enu\jre8\sqljdbc42.jar"  
> jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver"  
> jdbc\_user =\> "sa"  
> jdbc\_password =\> ".."

```
statement =>

```

This config worked on my test machine!

---

<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:** [December 25, 2019, 8:10am UTC](https://discuss.elastic.co/t/jdbc-want-to-connect-to-db-as-windows-user/209628/2 "2019-12-25T08:10:01Z")

</div>

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