PolyBase :: Changed database context to 'DWQueue'

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:

SQL Server 2019 Polybase installation error "The proposed new database owner is already a user or aliased in the database"

This means to me that Administrators cannot install PolyBase.

Is there any way out without dropping my Administrator?

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.

Method 1

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
bootstrap\log\20220617_120543\

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 🙂

All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply