Support > Forums > Getting Started > Getting SQL Error 42000 during Server Install

Getting SQL Error 42000 during Server Install

Ranjit Sankar

  • Reporter
  • Calender Icon May 21,2021 at 1:14 AM

Hi, while installing the OpenBots Server, we are getting a SQL Error.

[SQL_ERROR]: [SQL_STATE: 42000] Incorrect syntax near the keyword 'ADD'

We have a SQL-Express 2019 running with IIS on Windows 10, and we had also successfully installed the Agent/Studio.

Request help to resolve.

This forum has 46 topics, 113 replies, and was last updated 6 months ago by Support Agent

Ranjit Sankar

  • Participant
  • Calender Icon May 27,2021 at 3:16 PM

Hi Nataly & Team, thanks for getting this sorted.

As seen, it was due to multiple instances of SQLExpress running, and related issues.

thanks again.

Nataly Alvarado...

  • Participant
  • Calender Icon May 26,2021 at 2:17 PM

Hello Ranjit,

The error seems to be related to the SQL migration scripts executed when OB Server is installed. We will be in contact with you to better assist overpass this issue.

You are not authorized to reply, please click here to login and add your reply to this topic.