This article lists the fixes for common issues in Crow Canyon Data Sync Tool

1. Crow Canyon Data Sync Service Stopping immediately
2. Items from Database do not sync to the SharePoint list

Issue Symptom 1:

Exception occured while running the Sync Process. Erro Details: Login failed for the user the user ‘User Account’.

Cause:

SQL authentication is set to Windows Authentication mode only.

Resolution:

Set mixed mode authentication in SQL by following below steps  and restart the CrowCanyon Data Sync service.

Steps to enable the Mixed Mode Authentication:

1. Open SQL Server Management Studio Express.
2. Choose Windows Authentication from the Authentication drop down list.
3. Click Connect to open the Microsoft SQL Server Management Studio Express window.
4. Right-click the SQL instance and choose Properties to open the Server Properties – window.
5. Click Security on the left hand side.
6. Choose both SQL Server and Windows Authentication Mode on the right side.
7. Click OK to close the Server Properties – window.
8. Right-click the SQL instance and choose Restart.
9. Click Yes to restart the SQL server.

Validation: To check the authentication, logon to the SQL studio with SQL Authentication mode and it should allow logging in without  any errors.

Issue Symptom 2:

Crow Canyon Data Sync service runs but no items from the database will be synced in SharePoint. This generally happens when some of the files like .exe, .dll are downloaded from the browser and are not trusted. In this case, we do not see any error but the items sync will not start at all.

Cause:

Crow Canyon Data Sync service has dependency assembly files “Microsoft.SharePoint.Client.dll, Microsoft.SharePoint.Client.Runtime.dll” and they should present in the service installation folder and they are missed.

Resolution:

Stop Crow Canyon Data Sync service, place the missing dependency files in the installation folder, start the Crow Canyon Data Sync service.

Also, unblock all the package files in the installation folder by following below steps.

1. Right Click on the “Microsoft.SharePoint.Client.dll “ file, click properties, if “Unblock” button is visible under “General” tab at the bottom in the security column, click unblock. See sample screenshot below.
2. Repeat the above steps for all the files in the installation folder (Configuration.xml, CrowCanyon.DBSyncService.exe, InstallUtil.exe, Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll).