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?
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>
I think it is a new bug in SQL Change Automation.
I could fix it, with pressing the "Restore Default" button for the "Target Connection String" in the project properties in the debug register.
