Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

  • 7016362
  • 30-Mar-2015
  • 30-Mar-2015

Environment

NetIQ Security Manager 6.5.4
NetIQ Security Manager 6.5.3

Situation

Database installer throw the following error message:
Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.

Resolution

Either rename the sa account back to sa, or create an sa account to complete the installation/upgrade.  It does not need to have any admin privileges, just the name. 

Cause

When the installer cannot find the 'sa' account in SQL, it tries to insert the value NULL in the owner field, which causes the insert to fail.