question

RogerSalgadoIzaguirre-1509 avatar image
0 Votes"
RogerSalgadoIzaguirre-1509 asked saldana-msft edited

Error changing SCCM database

When I want to change the server where the SCCM database is stored, I receive the following error messages


ERROR: Failed to create SQL Server [server1.troncoso.com] certificate remotely.
ERROR: Failed to create SQL Server certificate on server server1.troncoso.com
Bootstrap operation failed.
Failed to create machine certificate on server server1.troncoso.com

Do you know any way to solve it?

windows-servermem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered AllenLiu-MSFT commented

Hi, @RogerSalgadoIzaguirre-1509

Thank you for posting in Microsoft Q&A forum.

Do you mean you are trying to move SCCM Database from the current SQL Server to a new SQL Server?
If so, you may need to export SQL Certificate from (Personal Certificates) in the new SQL Server and import it in (Trusted People) in SCCM Server.

You may refer to below thread for more details:
https://social.technet.microsoft.com/Forums/en-US/19aa9fe3-9137-4409-b751-c4ea30e92f48/sccm-fail-to-create-sql-server-certificate?forum=ConfigMgrMigration



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".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Is there any update on this thread?

0 Votes 0 ·