I have a problem upgrading SCOM SP1 to R2

Asked By Mitchell150 30 points N/A Posted on - 06/21/2011

Hi,

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.

Thanks.

Status: Open
Question Views: 1324
Answer Count: 1
Vote Up 3 Vote Down

Answer Accepted: No
Question Category: Development Software

Answered By alexx 5 points N/A #127430