We currently don't have the internal resources to debug MSSQL. Your best bet is to yourself write a pull request that fixes it.

Strange : questionIs is added.
Can you check the url with PGSQL ?

Hi, I solved by replacing dblib driver with MS SQL ODBC, version 17.6 . Newer versions aren't able to connect to SQL Server 2012 without encryption.

Hi, Denis: i checked DB and question hasn't been added. I tried to edit existing question, but changed were not saved. But, this survey was imported from lss file without problems. Now I try yo use ODBC instead of dblib.

thanks to everyone!

meanwhile, trying to activate survey, I found an ortographic error in two files:
application/models/SurveyActivator.php: mssql_drop_coulmn_with_constraints($this->survey->responsesTableName, 'id');
application/helpers/admin/activate_helper.php:function mssql_drop_coulmn_with_constraints($tablename, $columnname)

..and in SurveyActivator is missing the declaration:
require_once(DIR . '/../helpers/admin/activate_helper.php');
I added it at row 375, I hope is the right place.
without it I have a missing function error.

Hi, Denis: i checked DB and question hasn't been added. I tried to edit existing question, but changed were not saved. But, this survey was imported from lss file without problems. Now I try yo use ODBC instead of dblib.

Oh it's the redirect after the creation,
Link when create are like that /index.php?r=questionAdministration/create&surveyid=489424

Then : there are an hidden issue when create. Our system didn't check if it's really created after redirect.

Can you test with debug with 2 ?

About MS SQL ODBC and encryption : add :TrustedServerCertificate=1 at end of the connexionstring (after the database name)

Hi, for encryption: the problem is related to our servers: we have an old 2012 version, and I cannot upgrade it. it works only with a version of ODBC that doesn't force encryption to TLS 1.2.
I tried to set encryption=no and TrustServerCertificate=true or false but I didn't solve until I downgraded MS ODBC from 18 to 17.6 .

for MSSQL driver: using ODBC instead of dblib (in debian enabled by installing package php8.2_sybase) it seems to work.
I'm using pdo_sqlsrv and sqlsrv obtained from https://packages.microsoft.com/debian/10/prod/pool/main/m/msodbcsql17/

On one instance set :TrustedServerCertificate=1 work, without : no connexion …
IIS server (on both side for me) maybe ?
More a php-mssql option then.

Hi, Denis,
I do use Debian 12+nginx+php8.2.
I tried IIS and it worked flawless, but I don't want to use it in production.

I tried IIS and it worked flawless, but I don't want to use it in production.

It's not the purpose, just to find a way.

seems mssql accept TrustedServerCertificate only on IIS. Maybe some other way oin linux to get the good certificate OR accept any certificate. But it's not related to this issue ...

I read elsewehere that SQL Server 2012 doesn't support TLS 1.2 and it causes problems with all OSes with OpenSSL v3...

Great that the problem is solved. Please, can you leave some conclusions to add to doc?
Thanks!

If i don't make error : problem is NOT really solved

1. using dblib driver
2. Error seems hidden somewhere

But : hard to reproduce since need a server with DBlib driver

@zufolo441 : can you test with same server, with dblib and LimeSurvey 5 ?

Hi,
regarding Lime, there is a bug in application/models/SurveyActivator.php : it is unable to find function mssql_drop_coulmn_with_constraints() until I add

require_once(DIR . '/../helpers/admin/activate_helper.php');

declaration somewhere in file. There is an ortographic error in function name too.

regarding dblib, my opinion is that the problem is more OS/PHP/library related. There are problems with DDL: LS is unable to create tables.
Example: I was able to import survey from lss file, but I couldn't activate it.

In this moment I cannot do tests because I have only that server, I'm the only linux admin in a Microsoft-ed organization :-) so, I couldn't use PGSQL as I usually did.
In a rapid observation of LS code, it seemed to me that dblib and sqlserver drivers have quite the same treatment, for that reason I don't think the problem is in the php code...

I think compare LS5 against LS6 can be really intersiting
Same with LS3
Not compare code, just test if it work.

If it work on LS3 : it can woirk on LS5 and LS6 ;)

This issue should be fixed with fixes for 19578