I have a problem upgrading SCOM SP1 to R2
I want to upgrade SCOM SP1 to R2 Multi server environment, RMS and remote SQL 2008 SP1 Server. But I am experiencing some problems or rather errors during the upgrade process – see the error below.
"System Center Operation Manager 2007 R2 Setup
Error 25154.Failed to execute SQL script. Error Code: -2147217873 (Cannot insert the value NULL intoColumn ‘TableObjectId’, table ‘SCOM.dbo.DomainTable’; Column does not allow nulls. INSERT fails)”
My computer is running Windows Server 2003 and SQL 2008 SP1 Server. And I have Microsoft .Net framework 3.5 installed on it prior to upgrading it. I have also created a domain security group for the administrators’ accounts prior to upgrading SCOM and the Action Account for the management server has User privileges on the management server. Could I be missing out on something? I really need to upgrade my SCOM and any help will be appreciated.