SQL Server2008/SQL Server2012: Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
Posted by Karthick P.K on November 17, 2010
SQL Server 2008 : Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16
SQL Server 2012 : Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error
SQL Server 2008/2012 instance fails to start or hangs after service pack or Cumulative update installation.
Error
Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, 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.
Error: 574, Severity: 16, State: 0.
CONFIG statement cannot be used inside a user transaction.
Error: 912, Severity: 21, State: 2.
Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, 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.
Error: 3417, Severity: 21, State: 3.
Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error 15173, state 1, severity 16
Start SQL Server from command prompt using trace flag –T902 to disable script execution
1.Turn off Implicit transaction
{
EXEC sys.sp_configure N’user options’, N’0′
GO
RECONFIGURE WITH OVERRIDE
GO
}
2. SQL Server not able to create temp_MS_AgentSigningCertificate_database.mdf
Error:
{
Directory lookup for the file "P:\Data\temp_MS_AgentSigningCertificate_database.mdf" failed with the operating system error 2(The system cannot find the file specified.).
Error: 1802, Severity: 16, State: 1.
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
spid7s Error: 912, Severity: 21, State: 2.
spid7s Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 598, state 1, severity 25.
CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file ‘Q:\Data\temp_MS_AgentSigningCertificate_database_log.LDF’.
}
This error is raised when the default database location is invalid. Edit below registry to have a valid directory for default database location.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10.<Instance Name>\Setup\SQLDataRoot
3. Check if there are Orphan users in system databases and fix them.
{
EXEC sp_change_users_login ‘Report’;
}
4. If you see “error 15173, state 1, severity 16”
Ex: Script level upgrade for database ‘master’ failed because upgrade step ‘msdb110_upgrade.sql’ encountered error 15173, state 1, severity 16
Revoke the permissions granted on ‘##MS_PolicyEventProcessingLogin##’
you can use the below script to identify the users who have permissions granted on ‘##MS_PolicyEventProcessingLogin##’
select a.name,b.permission_name from sys.server_principals a,sys.server_permissions b,sys.server_principals c
where a.principal_id= b.grantee_principal_id and b.grantor_principal_id=c.principal_id and c.name = ‘##MS_PolicyEventProcessingLogin##’
Resolution
If none of the above resolves the issue then you can use Trace flag -T3601 which causes the first 512 characters of each batch being executed to be printed to the error log. Identify the batch which is failing and troubleshoot the batch.
If you liked this post, do like us on FaceBook at https://www.facebook.com/mssqlwiki and join our FaceBook group https://www.facebook.com/mssqlwiki#!/groups/454762937884205/
Karthick P.K | My Facebook Page |My Site| Blog space| Twitter
Disclaimer:
The views expressed on this website/blog are mine alone and do not reflect the views of my company. All postings on this blog are provided “AS IS” with no warranties, and confers no rights.
This entry was posted on November 17, 2010 at 5:02 AM and is filed under SQL Cluster Setup, SQL Server Setup, Startup failures. Tagged: CREATE FILE encountered operating system error 3(The system cannot find the path specified.) while attempting to open or create the physical file '\temp_MS_AgentSigningCertificate_database_log.LDF'., Directory lookup for the file temp_MS_AgentSigningCertificate_database.mdf failed with the operating system error 2(The system cannot find the file specified.)., error 15173, Error: 574, Script level upgrade for database 'master' failed because upgrade step 'msdb110_upgrade.sql' encountered error 15173, Severity: 16, SQLServer Browser, SQLServer Cluster, SQLServer2008 Setup, State: 0., State: 1., temp_MS_AgentSigningCertificate_database.mdf. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.
MSSQLWIKI 
FILESTREAM feature is disabled | SQLServerScribbles said
[…] SQL Server2008/SQL Server2012: Script level upgrade for database ‘master’ failed and run below statement to change file stream access level […]
Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said
[…] SQL Server2008/SQL Server2012: Script level upgrade for database ‘master’ failed because upgrade… […]
yoga pants small long length said
Spirit Voyage also offers variety of yoga accessories like yoga mats,
yoga rugs, yoga cushions. Womens yoga pants should
be convenient so as to be able to create free-flowing campaign. To avoid
any unwanted happenings during their yoga class.
hcg weight loss injections online said
He will sometimes guide you with extracting a unwanted food item like fatty, oily
in addition to carbohydrates. Let these mistakes
be your motivation for enhancing your body further.
This is greatly do to the fact that eating and lifestyle choices were not in place
once the weight had been eliminated.
hair restoration of the south said
Fortunately, there are a number of treatments available if you
suffer from this unfortunate condition. This is because targeting the hair shaft without damaging
the pigment of the skin can be quite a tricky process. Have Some Much
more Derm – Organic Care For The Locks.
marine refrigerator marina mile fort lauderdale fl said
It is defined as the lowering of the core body temperature.
With the high temperature sensitivity of some perishable goods, it’s easy to understand
why so many companies rely on vacuum insulated panels
such a Thermo – Cor to ensure the quality of their products.
Of course, lots of methods have evolved to try to avoid spooking fish out of your swim or
even stop them from stopping feeding in the possible case of some line shy fish, and having them leave
your swim.
diet menu said
The best part is you do not have to deny your sweet tooth using these quick weight loss diets.
Was it mixed with alcohol and sprayed it would be devastating, one can imagine to have.
“Never feeling hungry is not a sign of being healthy,” stated Dr.
best hcg homeopathic drops said
It not only provides strength and improve the blood pressure by regulating the blood circulation, but
also provides endurance and help with the overall immune system of the body.
These HCG products are available online if you can buy it from your
nearby stress. However, dieting with the use of the oil from coconuts
definitely works because it provides you with nutrition.
dunnage general mills box tops for education said
Artificial baits include spoons, jigs, ribbon baits, rattler
baits & streamer baits. The options within the area range from Myall Lakes houseboats, cottages,
apartments, cabins and guests houses, lodges and hotels among
many others. Freshwater fish can be placed in the live well on the boat, or on a stringer to
keep it alive until you are able to clean it.
market cash gift said
Cynthia Minnaar is a full-time internet marketer
and owner of She invites you to visit her internet marketing training website
for more link building tips. Learning to do business
online is just another skill that can be acquired in the same way we acquire other
skills. But other than those who just want to communicate with friends, old and new, social
media is also currently being taken advantage by business oriented people as
a way to reach their target clients and improve their businesses.
How To Fix Error 3417 Severity 21 State 3 Errors - Windows Vista, Windows 7 & 8 said
[…] SQL Server2008/SQL Server2012: Script level upgrade for … – SQL Server 2008 : Script level upgrade for database ‘master’ failed because upgrade step ‘sqlagent100_msdb_upgrade.sql’ encountered error 574, state 0, severity 16 …… […]
free translation said
I’m curious to find out what blog platform you are working with?
I’m having some small security issues with my latest website and I would like to find something more secure.
Do you have any solutions?
agen sbobet terpercaya said
I kjow this web site offers qualitty dependent content and
extra data, is there any other site which gives such things in quality?
situs Judi online terbaik said
Great web site. Lots of useful info here. I’m sending
it to several friends ans additionally sharingg in delicious.
And naturally, thank you in your sweat!