cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Neo4j ETL Tool: Connection failed. SQL state: S0001

'm trying to utilize Neo4j ETL Tool to Import Data From My SQL Server Database into the Neo4j Graph Database. I also enabled TCP/IP 1433 Port in SQL Server 2019 Configuration Manager and Authorized it by Firewall and Imported Suitable mssql-jdbc-8.2.2.jre8 file for JDBC Driver option. I already set

Connection name: test
Host:localhost
Type: MSSQL 
Database: my_database_name
Schema: my_db_schema 

and here is my connection URL:

jdbc:sqlserver://localhost:1433;databaseName=TSQLV4

I set all of the options fines but When I aim to Test and Save the connection I encounter with this weird error:

Connection failed. SQL state: S0001, message: Login failed for user ''. ClientConnectionId:33b259b2-650a-4017-94fa-b86cfc657c9e

and My SQL Server Services are all run in the background among them:

  • MSSQLSERVER
  • MSSQLSERVER Agent
  • MSSQLSERVER VSS Writer

do you have any idea to run the job?

1 REPLY 1

ameyasoft
Graph Maven

Did you provide username and password in your connection string?