Jump to content


SCSM 2010 SP1 DW Installation Issue

Recommended Posts

Hello everyone,


On my environment, I`m using a Windows Hyper-V Server 2008 SP1 with the following virtual machines:


- Domain Controller ( AD,DNS,DHCP,CA)

- Exchange 2010 SP1

- SCCM 2007 R2 SP2

- SCOM 2007 R2 ( SQL Server 2008 R2 Enterprise Ed. is also install on SCOM )

- SCSM 2010 SP1


I`m using Windows Server 2008 R2 SP1 for all virtual machines, and SQL Server 2008 R2.


As you already noticed, I`m trying to integrate all of them as you successfully did in your tutorials, but I have an issue with SCSM – Data Warehouse installation


Note: For the installation of all my servers in my environment I`m using Administrator as domain admin.



On the SCOM server I also have the SQL Server 2008 R2, as default instance ( I`m not using any named instances )


When I install SCCM 2007 aka ConfigMgr Server, I use a SPN for installing the server ( http://technet.microsoft.com/en-us/library/bb735885.aspx )


Everything works great with that !




Just to be clear, for SCSM I’m using the 2 servers scenario ( http://technet.microsoft.com/en-us/library/ff460945.aspx )


I`m also using separate service accounts for every component:


_svcSCSMService ( which is also a local administrator on both SCSM servers )

_svcSCSMWorkflow ( domain user )

_svcSCSMReporting ( domain user )

SCSMAdmins ( security group which includes the Administrator account as domain account )


On the first SCSM server, I install "Service Manager management server" component, everything went very well.


Now, on the second SCSM server, I continue installing " Service Manager data warehouse management server" and every time I receive the following error:


Configuring reporting - An error occurred while executing a custom action:_AssignDwAdminAsSsrsContentManagerOnRootFolder.1CA03A32_06E0



So from what I understand:


_AssignDwAdminAsSsrsContentManagerOnRootFolder.1CA03A32_06E0_4726_8E63_FEA4484D9D6F = Sets the reporting account as the Content Manager on the System Center folder in SQL Server Reporting Services.




I also found this:




You will need the following permissions when installing the data warehouse management server:

• Local administrator on the computer that you run Setup on

• Local administrator on the computer that will host the data warehouse database if on a remote computer

• Logged-in user must be a domain account

• Content Manager role in SQL Server Reporting Services at the site level (root)

• Sysadmin SQL Server role on the SQL Server instance where the data warehouse database is being created



I don`t understand how to set content manager role in SQL SRS, I set SCSMAdmin as sysadmin as a new login in SQL, but when I tried to add SCSMAdmins group to my sql reports page - Site Settings – Security – New Role Assignment (http://msdn.microsoft.com/en-us/library/ms156034.aspx )


I receive this error :




This is my users lists in AD:




This is my SQL services accounts ( all are domain users )




This is my SQL Login list:




SCSMAdmin account in SQL is sysadmin.


Here are the Logs


Does anyone have any idea or a hint on how to solve this issue ?


Thank you,


Best Regards,



Share this post

Link to post
Share on other sites



Okay I finally figure it out, SCOM and SCSM can't share the default instance !


All I have to do was to create another named instance in SQL 2008 R2, after that follow the steps from here:




and continue with the SCSM DW installation wizard, choose the new named instance instead of the default instance, it works !




I hope it helps the others too.



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...