SCSM 2010 SP1 DW Installation Issue

[BogdanR]

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 !

 

Now..

 

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:

 

http://technet.microsoft.com/en-us/library/ff461019.aspx

 

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,

 

Bogdan.

[BogdanR]

Hello,

 

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:

 

http://technet.microsoft.com/en-us/library/ff461215.aspx

 

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.

 

Regards.