Error 27506 - Incorrect syntax near '+'

Owned by Chris Hayes
Last updated: Oct 10, 2023
1 min read

Problem

You receive this error when trying to install the IRIS School Data Extractor on a machine running SQL 2005

error 27506

Solution

To resolve you need to click OK > run the setup file again > choose the Normal+ installation > reboot the server/PC > run the setup file again choosing the Normal installation. Then set DatabaseName=ContactGroup and InstanceName=(local)\CGDE) and proceed as normal with the rest of the install.