# Logstash.inputs.jdbc Unable to connect to database **URL:** \ **Category:** Logstash\ **Created:** [August 29, 2019, 7:56am UTC](https://discuss.elastic.co/t/logstash-inputs-jdbc-unable-to-connect-to-database/197276 "2019-08-29T07:56:38Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![whalien52](https://avatars.discourse-cdn.com/v4/letter/w/b5e925/32.png) [@whalien52](https://discuss.elastic.co/u/whalien52)\ **Post date:** [August 29, 2019, 7:56am UTC](https://discuss.elastic.co/t/logstash-inputs-jdbc-unable-to-connect-to-database/197276/1 "2019-08-29T07:56:38Z")
Hi, I am trying to connect an SQL database with Elasticsearch. So I have done all the changes in the config file of logstash and created an index in Kibana console. But I am getting error. My config file looks like this > input { > jdbc { > jdbc\_connection\_string =\> "jdbc:sqlserver://PG01GXXE\MSSQLSERVER01:1433;databaseName=VonageRPA;integratedSecurity=true;user=sa;password=" > jdbc\_driver\_library =\> "C:\Program Files\sqljdbc\_4.2\enu\jre8\sqljdbc42.jar" > jdbc\_driver\_class =\> "com.microsoft.sqlserver.jdbc.SQLServerDriver" > jdbc\_user =\> "PG01GXXE\ayantiadmin" > jdbc\_password =\> "pro#123" ``` statement => "SELECT * FROM WarbaLogs" ``` } } output { elasticsearch { hosts =\> ["localhost:9200"] index =\> "warbalog\_sql" } } and when I am running the config file following this command **logstash -f sql.conf** I am getting this error. > :non\_running\_pipelines=\>} > [2019-08-22T18:56:36,290][INFO][logstash.agent] Successfully started Logstash API endpoint {:port=\>9600} > [2019-08-22T18:56:37,266][ERROR][logstash.inputs.jdbc] Unable to connect to database. Tried 1 times {:error\_message=\>"Java::ComMicrosoftSqlserverJdbc::SQLServerException: Login failed for user 'PG01GXXE\ayantiadmin'. ClientConnectionId:bd5701ba-5ec6-462b-91da-ddbb8edebe2c"} > [2019-08-22T18:56:37,303][ERROR][logstash.javapipeline] A plugin had an unrecoverable error. Will restart this plugin. > Pipeline\_id:main > Plugin: \"PG01GXXE\ayantiadmin", jdbc\_password=\>, statement=\>"SELECT \* FROM WarbaLogs", jdbc\_driver\_library=\>"C:\Program Files\Java\sqljdbc\_4.2\enu\jre8\sqljdbc42.jar", jdbc\_connection\_string=\>"jdbc:sqlserver://PG01GXXE\MSSQLSERVER01:1433;databaseName=VonageRPA;integratedSecurity=true;user=sa;password=", id=\>"cd3dc08b51eae00482df46392e780908624dc52592e9fc29459b5a82c73ffa1a", jdbc\_driver\_class=\>"com.microsoft.sqlserver.jdbc.SQLServerDriver", enable\_metric=\>true, codec=\>\"plain\_f4d44d91-0d92-4b66-be7f-5dab66bfef21", enable\_metric=\>true, charset=\>"UTF-8"\>, jdbc\_paging\_enabled=\>false, jdbc\_page\_size=\>100000, jdbc\_validate\_connection=\>false, jdbc\_validation\_timeout=\>3600, jdbc\_pool\_timeout=\>5, sql\_log\_level=\>"info", connection\_retry\_attempts=\>1, connection\_retry\_attempts\_wait\_time=\>0.5, parameters=\>{"sql\_last\_value"=\>1970-01-01 00:00:00 UTC}, last\_run\_metadata\_path=\>"C:\Users\ayantiadmin/.logstash\_jdbc\_last\_run", use\_column\_value=\>false, tracking\_column\_type=\>"numeric", clean\_run=\>false, record\_last\_run=\>true, lowercase\_column\_names=\>true\> > Error: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Login failed for user 'PG01GXXE\ayantiadmin'. ClientConnectionId:bd5701ba-5ec6-462b-91da-ddbb8edebe2c > Exception: Sequel::DatabaseConnectionError > Stack: com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:217) > com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(com/microsoft/sqlserver/jdbc/tdsparser.java:251) > com.microsoft.sqlserver.jdbc.TDSParser.parse(com/microsoft/sqlserver/jdbc/tdsparser.java:81) > com.microsoft.sqlserver.jdbc.SQLServerConnection$1LogonProcessor.complete(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:2826) > com.microsoft.sqlserver.jdbc.SQLServerConnection.sendLogon(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:3082) > com.microsoft.sqlserver.jdbc.SQLServerConnection.logon(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:2361) > com.microsoft.sqlserver.jdbc.SQLServerConnection.access$100(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:44) > com.microsoft.sqlserver.jdbc.SQLServerConnection$LogonCommand.doExecute(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:2347) > com.microsoft.sqlserver.jdbc.TDSCommand.execute(com/microsoft/sqlserver/jdbc/IOBuffer.java:6276) > com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1794) > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1405) > com.microsoft.sqlserver.jdbc.SQLServerConnection.login(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:1069) > com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:905) > com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(com/microsoft/sqlserver/jdbc/SQLServerConnection.java:452) > com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(com/microsoft/sqlserver/jdbc/SQLServerDriver.java:1014) > java.lang.reflect.Method.invoke(java/lang/reflect/Method.java:498) > org.jruby.javasupport.JavaMethod.invokeDirectWithExceptionHandling(org/jruby/javasupport/JavaMethod.java:425) > org.jruby.javasupport.JavaMethod.invokeDirect(org/jruby/javasupport/JavaMethod.java:292) > C\_3a\_.Users.ayanti\_dot\_dey.Documents.ELKStack.logstash\_minus\_7\_dot\_3\_dot\_0.logstash\_minus\_7\_dot\_3\_dot\_0.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_22\_dot\_0.lib.sequel.adapters.jdbc.connect(C:/Users/ayanti.dey/Documents/ELKStack/logstash-7.3.0/logstash-7.3.0/vendor/bundle/jruby/2.5.0/gems/sequel-5.22.0/lib/sequel/adapters/jdbc.rb:221) > C\_3a\_.Users.ayanti\_dot\_dey.Documents.ELKStack.logstash\_minus\_7\_dot\_3\_dot\_0.logstash\_minus\_7\_dot\_3\_dot\_0.vendor.bundle.jruby.$2\_dot\_5\_dot\_0.gems.sequel\_minus\_5\_dot\_22\_dot\_0.lib.sequel.adapters.jdbc.RUBY$method$connect$0$ **VARARGS** (C\_3a\_/Users/ayanti\_dot\_dey/Documents/ELKStack/logstash\_minus\_7\_dot\_3\_dot\_0/logstash\_minus\_7\_dot\_3\_dot\_0/vendor/bundle/jruby/$2\_dot\_5\_dot\_0/gems/sequel\_minus\_5\_dot\_22\_dot\_0/lib/sequel/adapters/C:/Users/ayanti.dey/Documents/ELKStack/logstash-7.3.0/logstash-7.3.0/vendor/bundle/jruby/2.5.0/gems/sequel-5.22.0/lib/sequel/adapters/jdbc.rb) I have tried almost all the methods but still cant seem to find a way. ---
**Author:** ![guyboertje](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/guyboertje/32/31592_2.png) [@guyboertje](https://discuss.elastic.co/u/guyboertje)\ **Post date:** [September 2, 2019, 8:48am UTC](https://discuss.elastic.co/t/logstash-inputs-jdbc-unable-to-connect-to-database/197276/2 "2019-09-02T08:48:59Z")
Have you read this Stack Overflow Q+A? > ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [September 30, 2019, 8:48am UTC](https://discuss.elastic.co/t/logstash-inputs-jdbc-unable-to-connect-to-database/197276/3 "2019-09-30T08:48:59Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.