Sample Header Ad - 728x90

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 enter image description here *Retry* just results in the same message, after clicking *Cancel* the installation continues and then finishes with the install dialog showing the following: enter image description here 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: enter image description here
Asked by sTTu (146 rep)
Jul 26, 2021, 03:53 PM
Last activity: Aug 5, 2023, 08:04 AM