1,114 questions
Hi @Bojan Zivkovic •
Here required SQL configuration for DPM 2022 from microsoft article:
Please don't forget to accept helpful answer
Issues with Data Protection Manager 2022 installation
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 33%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBZ%3C/text%3E%3C/svg%3E)
Bojan Zivkovic
611
Reputation points
Hi, I have lost whole day trying to install DPM 2022 (remote SQL Server 2019 Cluster to host DPM DB) - all the time error is about SQL Server Management Tools are not installed on this machine. Please install SQL Tools compatible with the installed SQL Server version. I have tried with SSMS v19, then SSMS v18 (even SSMS v17) ... in vain.
Any help would be highly appreciated!
Microsoft System Center | Other
4 answers
Sort by: Most helpful
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 80%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Thameur-BOURBITA 36,266 Reputation points Moderator2023-12-26T15:15:26.5466667+00:00
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXM%3C/text%3E%3C/svg%3E)
XinGuo-MSFT 22,231 Reputation points2023-12-27T08:52:11.32+00:00 This helps you to track down log entries for specific error. Log files are located as follows:
DPM installation information: Logged on the DPM server at %ProgramFiles%\Microsoft System Center\DPM\DPMLogs.
-
Bojan Zivkovic 611 Reputation points
2023-12-28T08:38:28.67+00:00 [12/28/2023 2:03:15 AM] Information : [SQLSetupHelper.GetSqlCommandLineToolsPath] Found sql Tools which does not match with SQL DB version. Ignoring. Sql DB Version : 15.0.2000.5, Tools Version : 14.0.3026.27.
I simply find this insane - there are so many SSMS versions out there so how can I know which one to install and see this error become a past.
Sign in to comment -
-
XinGuo-MSFT 22,231 Reputation points
2023-12-29T01:45:09.6+00:00 Hi,
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.
According to the thread below, we could try installing the latest sqlcmd utility tools.
-
Bojan Zivkovic 611 Reputation points
2023-12-29T07:11:57.5066667+00:00 I have already tried SSMS 18.12.1 and 18.1 and nothing. In theory, could spend whole month trying all SSMS 18.x.x versions ... I remember well former test environment and DPM 1801 - everything was so straightforward and now with DPM 2022 big step backwards.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 57.99999999999999%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amardeep Saini 1,735 Reputation points Microsoft Employee2023-12-29T08:13:52.5866667+00:00 Hello @Bojan Zivkovic , request you to install SSMS along with SQLCMD on DPM machine and then try the installation and it should work. If you are still getting the same error. I would request you to please share the DPM Setup logs which is present on below mentioned location.
%ProgramFiles%\Microsoft System Center\DPM\DPMLogs
-
Bojan Zivkovic 611 Reputation points
2023-12-29T08:54:17.7433333+00:00 Solution was to install SQL Server Command Line Utilities ...
Sign in to comment -
-
Amardeep Saini 1,735 Reputation points Microsoft Employee
2023-12-29T09:09:51.5366667+00:00 Hello @Bojan Zivkovic , thanks you for contacting Microsoft. Your DPM installation issue is resolved by installing SQL Server Command Line Utilities on DPM server.
Request you to please click “Accept Answer” and Up-Vote. So that it could help other customer if they face the issue in future.