This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 18%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EXQ%3C/text%3E%3C/svg%3E)
Here is error log:
Description:
Script level upgrade for database 'master' failed because upgrade step 'ISServer_upgrade.sql' encountered error 15151, 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.
Core component of SQL Server for storing, processing, and securing data
It seems that you have tried to apply a Cumulative Update and this failed. Can this be correct? If so, which version of SQL Server and which CU?
If you look in the SQL Server errorlog, you can find more details on where things went wrong.
There are trace flags to work around this situation, but they should be seen as a temporary measure so that you can fix the root cause. And, no, it may not be trivial to fix.
And, oh, now I see your other post, and I understand Olaf's comment. Oh well.
It is sql server 2019 RTM. I tried to patch CU 30.
I use trace flag to start the service. But it is not a long term fix.
I cannot find ISServer_upgrade.sql script file. Where is it? I try to re-ren ISServer_upgrade.sql to get more detail message.
I would expect it to be in C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Install, but I don't it on my own machine. Then again, I don't have an SSISDB, which supposedly this script is aimed for.
By chance, I found https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/install/windows/sql-server-upgrade-failed-error-15151 which matches your error, and it suggest a solution. However, I suspect that there is more than possible reason for the failure.
If you remove the trace flag, I would expect SQL Server to run the script again - and fail. Check the SQL Server error log for errors that occur prior to this error.
Error description: Missing sa account password. The sa account password is required for SQL Authentication Mode.
Have you read that error message?
You have to pass the sysadmin account "sa" password, by using the /SAPWD parameter, see