Visual Studio isn't able to build sqlproj after I've updated it to Microsoft.Build.Sql 2.1 from 2.0.
- SqlPackage or DacFx Version: 170.2.70
- Microsoft.Build.Sql Version: 2.1
- Visual Studio Version: Community, March 2026 Feature Update, 18.4.3, bcd7427d
Steps to Reproduce:
Build sqlproj in Visual Studio.
microsoft.build.sql\2.1.0\tools\net472\Microsoft.Data.Tools.Schema.SqlTasks.targets(640,7):
Error: MSB4064: The "AcceleratedDatabaseRecovery" parameter is not supported by the "SqlBuildTask" task loaded from assembly:
Microsoft.Data.Tools.Schema.Tasks.Sql, Version=170.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 from the path: MICROSOFT VISUAL STUDIO\18\COMMUNITY\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLDB\DAC\Microsoft.Data.Tools.Schema.Tasks.Sql.dll.
Verify that the parameter exists on the task, the <UsingTask> points to the correct assembly, and it is a settable public instance property.
.nuget\packages\microsoft.build.sql\2.1.0\tools\net472\Microsoft.Data.Tools.Schema.SqlTasks.targets(558,5):
Error: MSB4063: The "SqlBuildTask" task could not be initialized with its input parameters.
Did this occur in prior versions? If not - which version(s) did it work in?
It worked for Microsoft.Build.Sql Version: 2.0
Visual Studio isn't able to build sqlproj after I've updated it to Microsoft.Build.Sql 2.1 from 2.0.
Steps to Reproduce:
Build sqlproj in Visual Studio.
Did this occur in prior versions? If not - which version(s) did it work in?
It worked for Microsoft.Build.Sql Version: 2.0