DPM 2022 installation: "SQL Server Management Tools not installed on this machine" error during install

adam900331 50 Reputation points
2023-03-13T10:37:19.7733333+00:00

Hy!

I am deploying a DPM 2022 evironment. A have a separate SQL server and a DPM server. The SQL server has SSMS 19.0.1 (latest). I have installed this SSMS version on DPM server before install the DPM 2022. THE DPM installation show the following error during the prerequsites check: SQL Server Management Tools not installed on this machine. Please install SQL Tools compatible with the installed SQL Server Version.

SQL Server version is: 2019 (15.0.2000.5)

Any idea, why cannot install the DPM 2022?

Thanks.

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
894 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,203 questions
0 comments
Accepted answer
  1. Seeya Xi-MSFT 16,461 Reputation points
    2023-03-14T05:58:39.9166667+00:00

    Hi @Lovas Ádám,

    This could be due to a compatibility issue between the version of SSMS that you have installed and the version of SQL Server that you are running.

    To resolve this issue, you can try one of the following options:

    Install an older version of SSMS: As DPM 2022 is a new release, it is possible that it is not fully compatible with the latest version of SSMS. You could try installing an older version of SSMS, such as SSMS 18.x.x, which is compatible with SQL Server 2019.

    Use the SQL Server Installation Center: The SQL Server Installation Center includes an option to install the SQL Server Management Tools separately from the SQL Server engine. You can launch the SQL Server Installation Center on the SQL Server machine and select the option to install the Management Tools. Then, try running the DPM 2022 installation again.

    User's image

    Install DPM 2022 on a separate machine: If the above options do not work, you can try installing DPM 2022 on a separate machine that does not have SSMS installed. This machine can still connect to the SQL Server instance on your SQL Server machine and use it as the DPM database.

    In addition, please refer to this MS document: https://video2.skills-academy.com/en-us/system-center/dpm/install-dpm?view=sc-dpm-2022image

    You can check these components by going in from the control panel.

    Best regards,

    Seeya

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

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jonas Hunziker 0 Reputation points
    2024-07-02T22:20:47.0666667+00:00

    For anyone else who, like me, found that the above answer does not resolve the issue (at least when trying to use DPM 2022 with SQL Server 2022), here is how I worked around it:

    • on the server you wish to install DPM 2022 on, go to c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\ and rename the "Binn" folder to "Binn.bak"
    • Copy that same "Binn" folder from your remote SQL Server 2022, in my case located in c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools, to the c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\ folder on your soon-to-be DPM server.
    • Re-run the pre-requisite scanner in the DPM 2022 installer. It should now pass the SQLTools requirement and allow you to install the software due to the SQLCMD.EXE being the same version as the SQL Server.

    I hope this helps someone because I wasted a tremendous amount of time with the requirement!

    0 comments