- You rename the sa account for an instance of Microsoft SQL Server 2005.
- You try to upgrade this instance of SQL Server 2005 to SQL Server 2008.
<date> <time> spid6s Cannot insert the value NULL into column 'owner_sid', table 'msdb.dbo.sysjobs'; column does not allow nulls. INSERT fails.
<date> <time> spid6s Error: 912, Severity: 21, State: 2.
<date> <time> spid6s Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 515, state 2, severity 16. This is a serious error condition which might interfere with regular operation and the database will be taken offline. If the error happened during upgrade of the 'master' database, it will prevent the entire SQL Server instance from starting. Examine the previous errorlog entries for errors, take the appropriate corrective actions and re-start the database so that the script upgrade steps run to completion.
<date> <time> spid6s Error: 3417, Severity: 21, State: 3.
This problem is fixed in SQL Server 2008 Service Pack 1 (SP1). Therefore, when you try to upgrade an instance of SQL Server 2005 to a version that is later than SQL Server 2008 SP1, this problem does not occur. You must install SQL Server 2008 together with SQL Server 2008 Service Pack 1 or a later update (this is also known as a "slipstreamed" version). For more information about SQL Server 2008 Service Pack 1, click the following article number to view the article in the Microsoft Knowledge Base:
How to obtain the latest service pack for SQL Server 2008
Article ID: 968829 - Last Review: Jul 29, 2011 - Revision: 1