# Connecting Neo4j Desktop to SQl server **URL:** \ **Category:** Projects & Collaboration\ **Created:** [March 26, 2021, 8:02am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900 "2021-03-26T08:02:14Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 26, 2021, 8:02am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/1 "2021-03-26T08:02:14Z")
Need help to connect Neo4j desktop to local sql Server 1. Have already installed the desktop version 1.4.3.exe 2. Have MSQL Management Studio v18.4 Need help to create a database on sql server and connect to neo4j desktop ---
**Author:** ![akollegger1](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/akollegger1/32/14828_2.png) [@akollegger1](https://community.neo4j.com/u/akollegger1)\ **Post date:** [March 26, 2021, 11:23am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/2 "2021-03-26T11:23:57Z")
Hello @saurabhpaul35 , Could you describe a bit more about what you'd like to set up? For example, something like an ETL flow between Neo4j and SQL Server? Best, ABK ---
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 26, 2021, 11:45am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/3 "2021-03-26T11:45:50Z")
I have SSMS setup on my system , on the other side ne04j desktop , how do i connect to ssms from neo4j , i tried creating localhost DB on ssms I'm not able to do it. I have attached my sql server window and neo4j desktop window please help. [localhostdb|496x119](https://community.neo4j.com/uploads/short-url/rpmBnEwMpPQdFt2FZtOBVaaO0Ee.png) ![sqlserver](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/a/f/afb0c5ca260a6d6b47779ab828c30b24ee07469c.png) ---
**Author:** ![akollegger1](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/akollegger1/32/14828_2.png) [@akollegger1](https://community.neo4j.com/u/akollegger1)\ **Post date:** [March 26, 2021, 1:08pm UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/4 "2021-03-26T13:08:41Z")
The best approach may be to use the Neo4j ETL tool. You can find information abou that here: > **[How-To: Neo4j ETL Tool - Developer Guides](https://neo4j.com/developer/neo4j-etl/)** > > Through this guide, you will learn how to take your data from a relational database or table format and import to Neo4j. Best, ABK ---
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 26, 2021, 1:33pm UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/5 "2021-03-26T13:33:29Z")
Thank you The ETL tool actually has options to connect to the SQL server but my server is a production one handled by client where i cannot connect directly instead I am trying to create a localhost access with widows authentication but I'm unable to do it. ---
**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\ **Post date:** [March 28, 2021, 4:53pm UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/6 "2021-03-28T16:53:09Z")
You need to download the appropriate jdbc driver corresponding your SQL version from MS site. For version 6.2 the driver: mssql-jdbc-6.2.2.jre8.jar. After downloading, copy the jar file to Neo4j 'plugins' folder and run this script: call apoc.load.driver("com.microsoft.sqlserver.jdbc.SQLServerDriver") For windows authentication, you need to copy the sqljdbc\_auth.dll into the C:\Windows\SysWOW64 directory. Finally, run the call apoc.load.jdbc() script. ---
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 29, 2021, 3:54am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/7 "2021-03-29T03:54:03Z")
I have admin access restrictions hence not able to download the drivers mentioned. ---
**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\ **Post date:** [March 29, 2021, 4:06am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/8 "2021-03-29T04:06:09Z")
Other choice is to export the data as a csv file and import into Neo4j database using LOAD CSV ---
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 29, 2021, 4:12am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/9 "2021-03-29T04:12:40Z")
What I am trying here is I have SQL server where in the DB's are production ones which i cannot do experiment , instead I want to create a localhost DB which has graph tables folder and that i wanted to connect to neo4j desktop. Have attached screenshot. ![jdbc connection](https://us1.discourse-cdn.com/flex021/uploads/neo4jcommunity/original/3X/5/3/536a801900e2047011c1c00c65a043682d325ec3.png) ---
**Author:** ![ameyasoft](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/ameyasoft/32/32639_2.png) [@ameyasoft](https://community.neo4j.com/u/ameyasoft)\ **Post date:** [March 29, 2021, 6:04am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/10 "2021-03-29T06:04:19Z")
Try Kettle ETL tool: > **[Kettle Etl Tool overview (Pentaho Data Integration)](https://etl-tools.info/en/pentaho/kettle-etl.htm)** > > Kettle Etl Tool overview (Pentaho Data Integration) ---
**Author:** ![saurabhpaul35](https://sea1.discourse-cdn.com/flex021/user_avatar/community.neo4j.com/saurabhpaul35/32/17451_2.png) [@saurabhpaul35](https://community.neo4j.com/u/saurabhpaul35)\ **Post date:** [March 29, 2021, 6:11am UTC](https://community.neo4j.com/t/connecting-neo4j-desktop-to-sql-server/35900/11 "2021-03-29T06:11:42Z")
Thank you apart from this tool is there any way I can do this because my manager has asked me to give demo today to create graph database in local instance and connect through neo 4j.