Share via

Cannot enumerate local SQL Server databases on Primary DPM 2025

Michael 46 Reputation points
2025-01-15T02:17:01.59+00:00

When attempting to create a new protection group for the primary DPM server’s database, errors 964 (Please make sure that writer is in good state) and 966 (Please make sure that SQL server instance is in good state) are generated when I refresh the primary DPM server in the Protection Group Wizard tree control. The SQL server is installed on the same system as the DPM server. All the databases except the DPM database give error 964 (master, etc.) while error 966 is given for the DPM database.

Any ideas to the cause? 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.
1,052 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. XinGuo-MSFT 20,396 Reputation points
    2025-01-15T07:31:46.8266667+00:00

    Hi,User's image

    https://zcusa.951200.xyz/en-us/troubleshoot/system-center/dpm/vnext-dpm-error-codes

    If the DPM SQL Server instance isn't running on the DPM server, install the DPM protection agent on the SQL Server computer before you can protect the DPM databases on that server.

    https://zcusa.951200.xyz/en-us/system-center/dpm/back-up-the-dpm-server?view=sc-dpm-2025#back-up-the-dpm-database

    0 comments
  2. Amardeep Saini 1,490 Reputation points Microsoft Employee
    2025-01-15T08:12:41.4933333+00:00

    Hi @Michael, Thank you for contacting us on Microsoft Q&A platform. Happy to help!

    I am assuming you might be using SQL 2022 for installing DPM 2025. Please make sure that below mentioned components are installed on DPM server:

    • SQL OLEDB V19 drivers (These drivers needed to be installed on SQL server if you are protecting SQL 2022 and above)
    • VC++ Redistributable 2022, 32 bits and 64 bits both. VC++ Redistributable 2022 64 bits is needed as pre-req for SQL OLEDB V19 drivers and VC++ Redistributable 2022 32 bits is required as 64 bit package has the dependency on it.

    After installing the above components, please restart DPM server and then try to protect DPM instance which should fix the issue.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

    0 comments

Your answer

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