Skip to main content

Unable to Connect to the SQL Server using SQL Host Service Account

Data Integration
  • Updated

    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

     

     

     



    Related articles

    Comments

    0 comments

    Please sign in to leave a comment.