Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

After updating, whenever I start the service of the server in configuration manager, it always stops then.

And I found the error in the log

2013-04-13 19:08:19.63 spid7s Error: 15174, Severity: 16, State: 1.

2013-04-13 19:08:19.63 spid7s Login '##MS_PolicyEventProcessingLogin##' owns one or more database(s). Change the owner of the database(s) before dropping the login.

2013-04-13 19:08:19.63 spid7s Error: 912, Severity: 21, State: 2.

2013-04-13 19:08:19.63 spid7s Script level upgrade for database 'master' failed because upgrade step 'sqlagent100_msdb_upgrade.sql' encountered error 15174, state 1, 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.

2013-04-13 19:08:19.63 spid7s Error: 3417, Severity: 21, State: 3.

2013-04-13 19:08:19.63 spid7s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.

2013-04-13 19:08:19.63 spid7s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.

Can anyone pinpoint why this is happening?

As I cannot start the server of SQL server, I cannot connect via management studio and edit anything. How can I edit, for example, the owner of the database?

share|improve this question

migrated from stackoverflow.com Apr 13 '13 at 15:45

This question came from our site for professional and enthusiast programmers.

1  
It is a problem to tackle with the help of Microsoft Support. Their upgrade script appears to be at fault. Best case is you can manually change the ownership of database ('master'?) away from '##MS_PolicyEventProcessingLogin##', and then proceed. –  hardmath Apr 13 '13 at 13:59
    
Did you try starting it up in single user mode (sqlservr.exe -m)? –  Aaron Bertrand Apr 13 '13 at 18:53
    
Have you seen this? Connecting using trace flag 902 and making sure to run the update as an admin were the big takeaways. –  Jason Quinones Apr 15 '13 at 16:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.