Error while installing cumulative update

Question

I am installing Cumulative Update Package 15 for SQL Server 2019 - KB5008996 since it seems there 's a known issue that causes my sql server polybase log to fill the harddisk
While installing I keep having operation failed , and looking at the logs I found this error :

Error: 18456, Severity: 14, State: 5.
Login failed for user 'NT Service\SSISScaleOutMaster150'. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>]

I tried to add the user NT Service\SSISScaleOutMaster150 to my sql server bu tht error keeps popping up ....
Whats wrong ??
An update which should fix a problem, that instead causes another problem... nice ....

Answer 1

Hi @leo del ciello ,

It about Integration Services (SSIS) Scale Out
Please open SSMS, connect to this instance, right-click on logins, and then New login to add it to SQL Server login.
The default configuration does not add this account to login automatically

https://social.msdn.microsoft.com/Forums/en-US/01bc1e67-fe20-49d5-95b2-74beb00473c0/ssis-scale-out-master-service-account

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Keep having this warning in C:\Program Files\Microsoft SQL Server\MSSQL15.MSSQLSERVER\MSSQL\Log\Polybase\dump\SQLDUMPER_ERRORLOG.log :

.....
.....
(4170:3CE8) 02/21/22 21:48:53, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, PatternForExtraFiles = <NULL>
(4170:3CE8) 02/21/22 21:48:53, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
(4170:3CE8) 02/21/22 21:48:53, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
(4170:3CE8) 02/21/22 21:48:53, ERROR , mpdwsvc.exe, String at 0000024FA8E62390 was not NULL terminated <---------
(4170:3CE8) 02/21/22 21:48:53, ACTION, mpdwsvc.exe, Not creating an additional dump, because dump for stack signature 00000001E6C19658 already exists.
.......

Answer 3

I am still waiting for Microsoft to give me an explaination about what's happening ....