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

Question

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.

Answer 1

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.

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://learn.microsoft.com/en-us/system-center/dpm/install-dpm?view=sc-dpm-2022

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

Answer 2

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!

Answer 3

Hi Jonas

I am in the same mess and getting the error of missing SQL Management Tools.

I had a look at my folder structure c:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170 or 180 but I can't find a folder TOOLS neither at my DPM machine or at my SQL machine.

Any suggestion what I am missing?

THX mame