microsoft / microsoft/DacFx

2.1.0 build issues in VS 2026

Open
#776 6 comments 11 reactions 0 assignees View on GitHub
area: ssdt bug
Dominant language
C#
Stars
460
Forks
29
Avg merge
4d 9h
Merged PRs (30d)
7

Description

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 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

Contributor guide

Open the contributing guide

Research direction

Start by reproducing the Visual Studio sqlproj build with Microsoft.Build.Sql 2.1 and inspect microsoft.build.sql\2.1.0\tools\net472\Microsoft.Data.Tools.Schema.SqlTasks.targets around lines 558 and 640. Compare the task inputs and loaded Visual Studio assembly with the working Microsoft.Build.Sql 2.0 setup. Done means the reported build succeeds without the MSB4064 or MSB4063 errors.

Written by the indexing model from the issue text.

Assessment

Tech stack
csharp, sql
Domain
build-system, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.