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:
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:
and I manually changed into: