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.

Joshua Thomas 15 Reputation points
2023-12-11T19:23:55.44+00:00 
 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.
Developer technologies | Visual Studio | Other
Developer technologies | Visual Studio | Other

A family of Microsoft suites of integrated development tools for building applications for Windows, the web, mobile devices and many other platforms. Miscellaneous topics that do not fit into specific categories.

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jesús Nacimiento 5 Reputation points
    2026-01-16T15:16:53.68+00:00

    Hi,

    I got same issue on VS2022 and VS2026. In my case I had to change the Target Connection String on Debug section on project properties to point to a SQL Server 2022 database (2025 if you set the Target to 2025) instead my local 2019 db file.

    I hope that helps

    Was this answer helpful?

    2 people found this answer helpful.
  2. Anna Xiu-MSFT 31,196 Reputation points Microsoft External Staff
    2023-12-12T10:24:27.46+00:00

    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.

     

    Was this answer helpful?

    2 people found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.