SCSM Data warehouse activation

Heba Wagih 116

Dears,

Could you help me with how to upgrade the SCSM data warehouse to a licensed edition (activate it)?

Andreas Baumgarten 108.7K Reputation points MVP

2022-01-25T11:31:20.187+00:00

Hi @Heba Wagih ,

Are there any additional questions to this topic?

If you found the answer helpful, it would be great if you please mark it "Accept as answer". This will help others to find answers in Q&A

----------

Regards
Andreas Baumgarten

2 answers

Andreas Baumgarten 108.7K Reputation points MVP

2022-01-16T09:51:21.557+00:00
Hi @Heba Wagih ,

depending on the SCSM version the activation can be done this way: https://video2.skills-academy.com/en-us/system-center/scsm/sm-license?view=sc-sm-2019
This is for SCSM 1801 and later.

As far as I know there are two options for older SCSM versions to activate a evaluation version:

Re-install the SCSM

Open a support request with Microsoft

----------

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

Regards
Andreas Baumgarten
Please sign in to rate this answer.
Heba Wagih 116 Reputation points

2022-01-16T11:38:53.197+00:00

It is SCSM2019 and the management server is activated but the SCSM data warehouse isn't.
is this command applicable for the SCSM data warehouse server activation ?
Set-SCSMLicense -ManagementServer <ManagementServer> -ProductId <Product Key>

Andreas Baumgarten 108.7K Reputation points MVP

2022-01-16T11:44:13.923+00:00

Hi @Heba Wagih ,

you can give it a try with activating the SCSM DWH server via Set-SCSMLicense -ManagementServer. I haven't tried it myself so far.

If it is not working you still have the option to re-install the SCSM DWH.

----------

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

Regards
Andreas Baumgarten

Heba Wagih 116 Reputation points

2022-01-17T14:49:23.51+00:00

Hi @Andreas Baumgarten
I had tried this command Set-SCSMLicense -"ManagementServer <ManagementServer> -ProductId <Product Key>"
and the event ID 3334 has been disappeared after that which is saying that the SCSM evaluation copy has been expired. But there are two different event IDs that have been appeared 33502 & 26319, please advise what should I do?

Andreas Baumgarten 108.7K Reputation points MVP

2022-01-17T15:05:40.667+00:00

Hi @Heba Wagih ,

if the activation of the SCSM DWH is not possible re-installing the SCSM DWH is an option. During the new installation of the SCSM DWH it's possible to provide the license key.

----------

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

Regards
Andreas Baumgarten

Heba Wagih 116 Reputation points

2022-01-31T07:50:42.04+00:00

Hi @Andreas Baumgarten
I tried to install the SCSM DWH using the same DB but the installation fails each time I tried that.
this is the error message
1- An error occurred while executing a custom action:_AssignSdkAccountAsSsrsPublisher
This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the correction are made, you can retry upgrade for this role.

2- An error occurred while executing a custom action:_CreateMOMRegKey
This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the correction are made, you can retry upgrade for this role.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Andreas Baumgarten 108.7K Reputation points MVP

2022-01-31T17:55:06.093+00:00

Hi @Heba Wagih ,

related to 1): Please take a look here:
https://social.technet.microsoft.com/Forums/en-US/42f14d82-8a3d-45b8-b0c7-31d2804b3fa1/failure-on-clean-install-of-service-manager-2012-r2-data-warehouse-installation-error-about?forum=setup
https://social.technet.microsoft.com/Forums/en-US/9439740b-c9ae-48c7-8e5d-cd4ffa35da73/scsm-2019-install-error-actionassignsdkaccountasssrspublisher?forum=setup

related to 2): Have you deleted the old entries in registry after deinstallation and before new installation?
HKLM\Software\Microsoft\Microsoft Operations Manager and HKLM\Software\Microsoft\System Center

----------

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

Regards
Andreas Baumgarten
Please sign in to rate this answer.
Heba Wagih 116 Reputation points

2022-02-01T09:24:54.973+00:00

For related to 1:
I removed the SSRS and install it again with a new database.
related to 2:
no, I didn't remove any registry.

Andreas Baumgarten 108.7K Reputation points MVP

2022-02-01T18:22:52.183+00:00

Hi @Heba Wagih ,

please delete the registry keys before you start the installation.

----------

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

Regards
Andreas Baumgarten

Heba Wagih 116 Reputation points

2022-02-02T09:26:01.583+00:00

I deleted them, but there is an error still appearing
An error occurred while executing a custom action:_AssignSdkAccountAsSsrsPublisher
This upgrade attempt has failed before permanent modifications were made. Upgrade has successfully rolled back to the original state of the system. Once the correction are made, you can retry upgrade for this role.

Andreas Baumgarten 108.7K Reputation points MVP

2022-02-02T09:39:36.55+00:00

Hi @Heba Wagih ,

there are a few details and solutions on this error message. You maybe have to try:

https://social.technet.microsoft.com/Forums/en-US/7d068ee3-1512-4dc1-9516-acc601ee58e8/service-manager-2012-r2-setup-fails-at-sql-server-reporting-services-setup?forum=setup (Answer from Stefan Johner)

https://social.technet.microsoft.com/Forums/en-US/9439740b-c9ae-48c7-8e5d-cd4ffa35da73/scsm-2019-install-error-actionassignsdkaccountasssrspublisher?forum=setup (Answer from Stefan Horz and devham)

https://social.technet.microsoft.com/Forums/en-US/42f14d82-8a3d-45b8-b0c7-31d2804b3fa1/failure-on-clean-install-of-service-manager-2012-r2-data-warehouse-installation-error-about?forum=setup (Answer from Jan Vidar Elven and philipzempel)

If nothing works, opening a support case with Microsoft Support is an option.

----------

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

Regards
Andreas Baumgarten
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

SCSM Data warehouse activation

2 answers

Your answer