All we need is an easy explanation of the problem, so here it is.
I’m installing PolyBase on the latest SQL Server 2019.
During the installation I’m incurring in this error: https://www.youtube.com/watch?v=Oxd8yeiBfig (sorry for the video quality)
The proposed new database owner is already a user or aliased in the database. Changed database context to 'DWQueue'.
Yes, this error has already been addressed here:
This means to me that Administrators cannot install PolyBase.
Is there any way out without dropping my
How to solve :
I know you bored from this bug, So we are here to help you! Take a deep breath and look at the explanation of your problem. We have many solutions to this problem, But we recommend you to use the first method because it is tested & true method that will 100% work for you.
Only administrators can install features to the SQL Server.
All the information should be in the summary_xxxx.txt and the other log files located in
c:\program files\microsoft sql server\150\setup
but the workaround in the other post holds.
Wait for the error to pop up. Connect to the SQL Server using SSMS and drop your user from the DWQueue database
USE DWQueue GO DROP USER [DOMAIN\YOURUSENAME] GO
Go back to the setup and click retry and then do the same for the DWConfiguration and DWDiagnostics databases if the same error pops up there.
Note: Use and implement method 1 because this method fully tested our system.
Thank you 🙂