VS2019 error with SQL Change Automation: "Keyword not supported: 'multiple active result sets'"

Question

I don't know where this error comes from at all. I have set up SQL Change Automation in VS2019 and began to get these errors for each .sqlproj solution I have. The errors are marked in the .sqlproj file, but no line is given for any of them.

I also don't can't find those words in the .sqlproj files, nor "MultipleActiveResultSets". I don't have them in the .sqlproj.users files neither.

Does anyone know if this is a known error with SQL Change Automation?

Answer 1

This issue of SQL Change Automation has been reported in their forum discussion 87146

There you can find the workaround:

unload the project, then modify the connection string from "Multiple Active Result Sets" to "MultipleActiveResultSets" (remove the spaces).

I found the connection string in the [project].sqlproj.user file.

In some project I also had to remove the spaces from "Trust Server Certificate".

For instance, it used to say:

<TargetConnectionString>Data Source=localhost;Initial Catalog=Dbname;Integrated Security=True;Persist Security Info=False;Pooling=False;Multiple Active Result Sets=False;Encrypt=False;Trust Server Certificate=False</TargetConnectionString>

and I manually changed into:

<TargetConnectionString>Data Source=localhost;Initial Catalog=Dbname;Integrated Security=True;Persist Security Info=False;Pooling=False;MultipleActiveResultSets=False;Encrypt=False;TrustServerCertificate=False;</TargetConnectionString>