Hello Team, i am trying to build a sql project with msbuild using self hosted windows agent in AKS but iam facing the error

Question

"C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\MSBuild\Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" was not found. Also, tried to find "Microsoft\VisualStudio\v11.0\SSDT\Microsoft.Data.Tools.Schema.SqlTasks.targets" in the fallback search path(s) for $(MSBuildExtensionsPath) - "C:\Program Files (x86)\MSBuild" . These search paths are defined in "C:\Program Files (x86)\Microsoft Visual Studio\2019\BuildTools\MSBuild\Current\Bin\MSBuild.exe.Config". Confirm that the path in the <Import> declaration is correct, and that the file exists on disk in one of the search paths.

the build works fine with the self hosted Windows agent hosted in Azure can you point me where iam doing the mistake

also would like to know is linux servers capable of building sql projects and if yes can you send me a link for reference

Answer 1

Hello anil nair1,

Thank you for posting in Microsoft Community forum.

Based on the description, I understand your question is related to SQL/AKS. 

Since there are no engineers dedicated to SQL/AKS in this forum. In order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

Here is the link for Q&A forum.

Questions - Microsoft Q&A

Have a nice day.

Best Regards,

Haijian Shan