DPM 2019 installation issue connecting to SQL 2019

Zachary Hamilton 201 Reputation points
2020-10-20T18:55:34.803+00:00

Hello,

I am attempting to install DPM 2019 on a new virtual machine with Server 2019. I have installed SQL 2019 locally. I have created a domain account, "sa_sql_dpm". I am running the DPM 2019 setup as Administrator, but I get an error:

33666-screenshot-2020-10-20-143201.png

So let's walk through these:

  1. I'm RDP'd into the computer, so yes.
  2. I followed the steps as listed to create a firewall rule, but for now, I've disabled the firewall.
  3. I've tried with both my AD administrator account and the sa_sql_dpm account. I have added sa_sql_dpm to the local Administrators group on the server, as well as assigning it the "public" and "sysadmin" Server Roles in SQL Server Management Studio. It also has User Mapping to "master" and "msdb". The domain admins group also has these settings.
  4. This service is running, set to automatic, logging in as Local System.
  5. SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for MSSQLSERVER -> TCP/IP = Enabled.

I'm no DPM or SQL expert, but I think I've checked everything and I'm still dead in the water. Any help would be appreciated.

Thanks,

Zachary Hamilton

P.S. Is there no tag for System Center or Data Protection Manager? Geez.

Windows Server 2019
Windows Server 2019
A Microsoft server operating system that supports enterprise-level management updated to data storage.
3,456 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.
12,693 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,117 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Leon Laude 85,651 Reputation points
    2020-10-20T18:57:49.383+00:00

    Hi @Zachary Hamilton ,

    DPM is currently not supported in the Q&A forums, the supported products are listed over here https://learn.microsoft.com/en-us/answers/products (more to be added later on).

    You can ask the experts in the dedicated DPM forum over here:
    https://social.technet.microsoft.com/Forums/en-us/home?category=dpm

    ----------

    (If the reply was helpful please don't forget to upvote or accept as answer, thank you)

    Best regards,
    Leon

    0 comments
  2. Erland Sommarskog 100.9K Reputation points MVP
    2020-10-20T21:10:07.86+00:00

    I don't know anything about DPM, but I know SQL Server. Exactly what did you specify for the instance when you attempted to install DPM? The error message makes me think that DPM Setup does not find the SQL Server instance, so it is immaterial which permissions you ave set.

    I get the feeling that you specified an instance name of MSSQLSERVER when you should have specified a default instance.

    As I said, I don't know DPM, but if you can add a screen shot where you configure the instance, that could be helpful.

    0 comments
  3. CathyJi-MSFT 21,086 Reputation points Microsoft Vendor
    2020-10-21T01:58:59.783+00:00

    Hi @Zachary Hamilton

    You have posted the issue on DPM forum. This link is your thread on DPM forum. You have also got the solution from Leon.

    In order to close this thread, please kindly mark useful reply as answers. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

    Best regards,
    Cathy

    0 comments