In ADS and VSCode: Cannot build sdk style sql projects after microsoft.sql-database-projects update 5/15/2025: error MSB4181: The "SqlBuildTask" task returned false but did not log an error.

[thinklikesqlhns]

Does this issue occur when all extensions are disabled?: Cannot reproduce with extension disabled, as this directly involves an extension

• VS Code Version: 1.100.1
• OS Version: Windows 11

Steps to Reproduce:

1. Create a valid Azure Synapse Sql Pool database project
2. Build the project from the database projects pane
3. Build will fail with the following message: {BaseDirectory}.nuget\packages\microsoft.build.sql\0.2.5-preview\tools\netstandard2.1\Microsoft.Data.Tools.Schema.SqlTasks.targets(544,5): error MSB4181: The "SqlBuildTask" task returned false but did not log an error.

[dzsquared]

What version of the SQL Database Projects extension is installed? Current is 1.5.2

In extension settings (VS Code settings > Extensions > Database Projects), is there a "Microsoft Build Sql Version" set?

[thinklikesqlhns]

My version is also 1.5.2. I believe this was an error in my project, or something that changed in how the project could be built. I recreated the database project from scratch, copied my folders over to it, and was able to get it building again.

[ssreerama]

It appears this might have been a transient issue during the initial project setup, as @thinklikesqlhns pointed out.

@thinklikesqlhns , do you think we can go ahead and close this issue? If you're still encountering problems and can share the repro steps, we’d be happy to take another look. Thanks