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.