When I try to run a project or solution i get the following error message in my build drop down window in the details. how can I resolve this. Ive updated my SQL server SSMS to the latest update.

Question

When I try to run a project or solution i get the following error message in my build drop down window in the details. how can I resolve this. Ive updated my SQL server SSMS to the latest update.

Joshua Thomas 15

 Build started: Project: Database1, Configuration: Debug Any CPU ------
		Database1 -> C:\Users\jfrie\Desktop\SSIS TASK\Database1\bin\Debug\Database1.dll
		Database1 -> C:\Users\jfrie\Desktop\SSIS TASK\Database1\bin\Debug\Database1.dacpac
------ Deploy started: Project: Database1, Configuration: Debug Any CPU ------
C:\Users\jfrie\Desktop\SSIS TASK\Database1\bin\Debug\Database1.sql: Error:  Deploy72002: A project which specifies SQL Server 2022 or Azure SQL Database Managed Instance as the target platform cannot be published to SQL Server 2019.
Done building project "Database1.sqlproj" -- FAILED.

Build FAILED.

Anna Xiu-MSFT 31,056 Reputation points Microsoft External Staff

2023-12-25T10:54:10.4566667+00:00

Hello, I have not heard from you for a couple of days. Please let me know if there is anything that I can help here.

You can update your VS to the latest version and create a new project to check it again.

1 answer

Your answer

Anna Xiu-MSFT 31,056 Reputation points Microsoft External Staff

2023-12-25T10:54:10.4566667+00:00

Hello, I have not heard from you for a couple of days. Please let me know if there is anything that I can help here.

You can update your VS to the latest version and create a new project to check it again.

Answer 1

Anna Xiu-MSFT 31,056 Microsoft External Staff

Hi @Joshua Thomas,

Welcome to Microsoft Q&A!

Please right-click your project in the Solution Explorer > Properties > Project Settings > change the project’s Target platform to SQL Server 2019.

Then, rebuild the project.

Sincerely,

Anna

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Klaustin 0 Reputation points

2025-01-27T04:16:02.31+00:00

What are you implying here? The project requires SQL Server 2022, but you set it back 2019? This must be some kind of a joke, right?

Share via

When I try to run a project or solution i get the following error message in my build drop down window in the details. how can I resolve this. Ive updated my SQL server SSMS to the latest update.

1 answer

Your answer