# Creating a **URL:** \ **Category:** CData Sync\ **Tags:** question\ **Created:** [May 24, 2024, 1:16pm UTC](https://community.cdata.com/t/creating-a/724 "2024-05-24T13:16:02Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 1:16pm UTC](https://community.cdata.com/t/creating-a/724/1 "2024-05-24T13:16:02Z")
Hi, When I try to create a SQLServer connection for a local SQL Express install, CData Sync is throwing the following error: System error: UnknownHostException - No such host is known (DATA-DEV2\SQLEXPRESS) I am able to connect to the server with SSMS but for some reason CData cannot find it. CData and SQL Express are on the same server. What am I missing? Thanks. ---
**Author:** ![DougN\_Nouria](https://avatars.discourse-cdn.com/v4/letter/d/e0b2c6/32.png) [@DougN\_Nouria](https://community.cdata.com/u/DougN_Nouria)\ **Post date:** [May 24, 2024, 1:21pm UTC](https://community.cdata.com/t/creating-a/724/2 "2024-05-24T13:21:14Z")
This post has some useful things to check (firewall, configuring SQL express to allow TCP connections, and so on). [Cannot connect to SQL Server Express - Microsoft Q&A](https://learn.microsoft.com/en-us/answers/questions/281748/cannot-connect-to-sql-server-express) Try changing the server name from “DATA-DEV2” to “localhost” in your connection string, if they are on the same machine. ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 1:32pm UTC](https://community.cdata.com/t/creating-a/724/3 "2024-05-24T13:32:23Z")
Thank you for the response. I have tried localhost to no avail. I have also tried the local IP address with similar results. The thing is though I can connect to the SQLExpress both locally and remotely using SSMS so I know the database instance is up and running. I just can’t connect to it with CData Sync. Please see the error log posted below. ![863dda0a-6a28-4452-9008-a3411a5f6d63.png](https://us1.discourse-cdn.com/cdata/original/2X/0/03393df724723b33e6cf22f2808b23c2cc6be75c.png) Here is the error log: 2024-05-24T08:28:00.354-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: port = 1433 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: customizedlog = sync.connection.CustomizedLogger@7ce74ca8 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: authscheme = Password 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: server = localhost\SQLEXPRESS 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: useconnectionpooling = False 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: user = qbuser 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: verbosity = 5 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: other = cdataapp=DataSync 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: oemkey = \*\*\*\*\* 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: password = \*\*\*\*\* 2024-05-24T08:28:00.355-0500    2    [56|Q-Id]    [INFO|Connec] Connection Property: database = QBMay24th 2024-05-24T08:28:00.356-0500    1    [56|Q-Id]    [INFO|Connec] Executed connect: Error: System error: UnknownHostException - No such host is known (localhost\SQLEXPRESS) 2024-05-24T08:28:00.356-0500    2    [56|Q-Id]    System error: UnknownHostException - No such host is known (localhost\SQLEXPRESS) XcoreXsqlX230X8839.rge     at java.base/java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)     at java.base/java.net.InetAddress$PlatformNameService.lookupAllHostAddr(Unknown Source)     at java.base/java.net.InetAddress.getAddressesFromNameService(Unknown Source)     at java.base/java.net.InetAddress$NameServiceAddresses.get(Unknown Source)     at java.base/java.net.InetAddress.getAllByName0(Unknown Source)     at java.base/java.net.InetAddress.getAllByName(Unknown Source)     at java.base/java.net.InetAddress.getAllByName(Unknown Source)     at java.base/java.net.InetAddress.getByName(Unknown Source)     at XcoreXsqlX230X8839.to$a.f(Unknown Source)     at XcoreXsqlX230X8839.to$a.run(Unknown Source) 2024-05-24T08:28:00.356-0500    1    [56|Q-Id]    [INFO|Connec] Closed SQL connection 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: port = 1433 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: customizedlog = sync.connection.CustomizedLogger@7ce74ca8 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: authscheme = Password 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: server = localhost\SQLEXPRESS 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: useconnectionpooling = False 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: user = qbuser 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: verbosity = 5 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: other = cdataapp=DataSync 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: oemkey = \*\*\*\*\* 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: password = \*\*\*\*\* 2024-05-24T08:28:00.358-0500    2    [57|Q-Id]    [INFO|Connec] Connection Property: database = QBMay24th 2024-05-24T08:28:00.359-0500    1    [57|Q-Id]    [INFO|Connec] Executed connect: Error: System error: UnknownHostException - localhost\SQLEXPRESS 2024-05-24T08:28:00.359-0500    2    [57|Q-Id]    System error: UnknownHostException - localhost\SQLEXPRESS XcoreXsqlX230X8839.rge     at java.base/java.net.InetAddress$CachedAddresses.get(Unknown Source)     at java.base/java.net.InetAddress.getAllByName0(Unknown Source)     at java.base/java.net.InetAddress.getAllByName(Unknown Source)     at java.base/java.net.InetAddress.getAllByName(Unknown Source)     at java.base/java.net.InetAddress.getByName(Unknown Source)     at XcoreXsqlX230X8839.to$a.f(Unknown Source)     at XcoreXsqlX230X8839.to$a.run(Unknown Source) 2024-05-24T08:28:00.359-0500    1    [57|Q-Id]    [INFO|Connec] Closed SQL connection ---
**Author:** ![SalD](https://avatars.discourse-cdn.com/v4/letter/s/c5a1d2/32.png) [@SalD](https://community.cdata.com/u/SalD)\ **Post date:** [May 24, 2024, 2:46pm UTC](https://community.cdata.com/t/creating-a/724/4 "2024-05-24T14:46:54Z")
I was able to make it work with a full SQL install. The SQL Express did not work for me. If anyone finds a way to make SQL Express work please let me know. For now I can move on. ---
**Author:** ![Ankit\_Singh](https://sea3.discourse-cdn.com/cdata/user_avatar/community.cdata.com/ankit_singh/32/1614_2.png) [@Ankit\_Singh](https://community.cdata.com/u/Ankit_Singh)\ **Post date:** [May 27, 2024, 7:23am UTC](https://community.cdata.com/t/creating-a/724/5 "2024-05-27T07:23:24Z")
Hey @SalD CData Sync connects to SQL Server using SQL Server Authentication **(Auth Scheme=Password).** Normally, with SQL Server Express, SQL Authentication is disabled on the server level. The error you are getting is documented here: [MSSQLSERVER\_18456 - SQL Server | Microsoft Learn](https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-18456-database-engine-error?view=sql-server-ver16#login-failed-for-user-username-or-login-failed-for-user-domainusername) You can check this by following the steps on your SSMS: 1. In SQL Server Management Studio (SSMS) Object Explorer, right-click the server and then select Properties. 2. On the Security page, under Server authentication, select **SQL Server and Windows Authentication Mode.** 3. In the SQL Server Management Studio dialog box, select OK to acknowledge the requirement to restart the SQL Server. 4. In Object Explorer, right-click your server, and then select Restart. If SQL Server Agent is running, it must also be restarted. ![f9ed9cb3-a078-4e69-ac15-d3b7ddcb3342.png](https://us1.discourse-cdn.com/cdata/original/2X/5/5d1228f82f1ec9aebac8c56569e3642611240293.png) If you have already tried this, and it still doesn’t work, it’d be best to check the network access by checking the IP Port configurations in SQL Server Configuration Manager and ensure all the IPs are active. ![c31f32a3-73d0-49cc-970a-19d1b1f5f368.png](https://us1.discourse-cdn.com/cdata/original/2X/1/1ed7a9ba1edc7888eb49bd7e1fd6104ea1224ff9.png) I hope this helps! 🙂