Error: SQL Script parse error: invalid syntax, during SmartConnect install

Published: Mar 09, 2018
Post Author Written by eOne Solutions

When installing SmartConnect we are getting the error message, SQL script parse error: invalid syntax. The install then rolls back all actions. We have tried installing several versions of SmartConnect with the same results on each one.


In this case the user was entering a SmartConnect user password that contained a single quote (‘). When we removed the single quote from the password, the install worked as expected.

Feeling stuck? Get the support and guidance you need to help you power through any data challenge

We're on your integration team. Connect with our people and let us know how we can help you.