I've recently performed an in-place upgrade of the default instance of a SQL Server 2016 to SQL Server 2019 (CU11).
I'm trying to add the Polybase feature but am unable to resolve this error that occurs during installation:
Error installing SQL PolyBase
The proposed new database owner is already a user or aliased in the database. Changed database context to 'DWQueue'.
Error code: 0x84BB0001
The following error dialog appears during the installation process
Retry just results in the same message, after clicking Cancel the installation continues and then finishes with the install dialog showing the following:
If I re-run the setup it thinks Polybase is installed (however it's not, connecting using SSMS still informs me I have to install Polybase). I have to manually run msiexec /x {6FDD1CAA-79C4-43B0-9483-5BD503E656DC}
to remove it before I can retry.
During setup I provided domain accounts for the service setup, there's nothing else to configure.
Can anyone shed any light on this error and what I can do to install successfully?
Edit
When in the setup process and presented with the Service Accounts screen for Polybase Engine and Polybase Data Movement, the text at the top of the screen states "Microsoft recommends that you use separate account for each SQL Server service."
However if I specify a different Account Name & password for these services it produces an error and you cannot proceed:
Best Answer
So I have found a workaround for this issue.
After determining the error is arising from the installation process trying to add the user account under which the Setup.exe is running to the
DW...
databases that it creates (where the user already exists).When the error
The proposed new database owner is already a user or aliased in the database.
appears Idropped
the user (me) from the database and proceeded toretry
.It then continued and raised the same error for the
DWDiagnostics
database, so I repeated the process to drop myself from that database also.After which, setup continued and...
So I believe this is a bug with the Polybase installation script, the workaround being to delete the user running the installation from the
DW...
databases during installation.