Please help us help you and fill where relevant:
LimeSurvey version: [see right hand bottom of your LimeSurvey admin screen]
Own server or LimeSurvey Cloud:
Survey theme/template:
==================
We have just upgraded our Lime Survey (own server) from 6.15.2 to 6.15.15 and unable to access anything due to the following SQL error. We have other environments against MySQL which have upgraded fine, but need this environment to be MSSQL.

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'.

When trying to run the db update command manually;

Update sqlsrv:Server=10.174.129.118;TrustServerCertificate=1;Database=limesurvey with prefix :lime_ from 636 to 637
CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. in /var/www/html/vendor/yiisoft/yii/framework/db/CDbCommand.php:543
Stack trace:
#0 /var/www/html/vendor/yiisoft/yii/framework/db/CDbCommand.php(415): CDbCommand->queryInternal()
#1 /var/www/html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryRow()
#2 /var/www/html/application/models/LSActiveRecord.php(72): CActiveRecord->query()
#3 /var/www/html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1494): LSActiveRecord->query()
#4 /var/www/html/application/models/Survey.php(1003): CActiveRecord->findByPk()
#5 /var/www/html/application/helpers/common_helper.php(3786): Survey->findByPk()
#6 /var/www/html/application/helpers/update/updatedb_helper.php(3108): fixLanguageConsistency()
#7 /var/www/html/application/helpers/update/updatedb_helper.php(154): fixLanguageConsistencyAllSurveys()
#8 /var/www/html/application/commands/UpdateDbCommand.php(46): db_upgrade_all()
#9 /var/www/html/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run()
#10 /var/www/html/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#11 /var/www/html/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#12 /var/www/html/application/commands/console.php(77): CApplication->run()


 

Apologies, upgrading from 6.15.9 to 6.15.15

I highly recommend to create a bug report.

How was this updated?

Manually? --> Bug report
Via "Comfort Update"? --> Bug report and support ticket.

The lead developers hardly show up in the forum, therefore you should make a bug report. (bugs.limesurvey.org).

If you are a paying customer of "comfort update" you can also create a support ticket with Limesurvey GmbH.

MsSQL is always tricky, because Limesurvey is mainly developed (and tested) on MySQL. So sometimes things like this might slip through.