Error while installing MS SQL Server, DWDiagnostics database currently in use

Pratik Sharma Bhusal 1 Reputation point
2022-04-10T10:39:52.557+00:00

TITLE: Microsoft SQL Server 2019 Setup


The following error has occurred:

Cannot drop database "DWDiagnostics" because it is currently in use.

Click 'Retry' to retry the failed action, or click 'Cancel' to cancel this action and continue setup.

For help, click: https://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft%20SQL%20Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=15.0.4013.40&EvtType=0x7590AFD6%25400x9A41B222


BUTTONS:

&Retry
Cancel


SQL Server Other
{count} votes

1 answer

Sort by: Most helpful
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2022-04-10T12:03:50.217+00:00

    That's an installation I've never seen before.

    When you ran the setup wizard, did you opt to install the Polybase feature? Do you plan to use Polybase? (The database in the error message is part of Polybase.)

    What happens if you press Retry?


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.