Error Message experienced when running WOScan Sync inside of Sage:

Unable to connect to SQL server using SQL Host account XXXX\xxxxxxx with DSN = WOSCAN

mceclip0.png

Fix:  Create a ODBC Connection on the workstation that is getting the error.

SQL Native Client

mceclip1.png

Name: WOSCAN and connect to the instance of SQL for WOSCAN

mceclip2.png

Then use SQL Server Authentication 

User:  Syncserver

PW:  P@$$w0rd

mceclip3.png

Then use default database as WoscanServerDEV

mceclip4.png

Click Next

mceclip5.png

 

After, Run the sync again in SAGE