SQL Server 2019 Polybase installation error "The proposed new database owner is already a user or aliased in the database"
1
vote
1
answer
1583
views
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:

Asked by sTTu
(146 rep)
Jul 26, 2021, 03:53 PM
Last activity: Aug 5, 2023, 08:04 AM
Last activity: Aug 5, 2023, 08:04 AM