/ Sitecore

Sitecore Desktop Database selection shows duplicate or non-existent database

Do you see multiple instance of db listed in the database switcher on Sitecore Desktop after migrating to Sitecore 9. Hope I am not alone with this issue. After some search, I came to know that's a common issue, if you dont take care of the config files as a part of the migration. The following places can help you identify the issue.

Connection String
Ensure the ConnectionStrings.config has valid entries and no duplicates. Mostly we will have this valid. The next place to hit is the showconfig.aspx which had been always a life saver.

Showconfig.aspx
Open /sitecore/admin/ShowConfig.aspx from your instance and do a search for the <database id="dbname" or just id="dbname". In my case dbname was master, Find the non existent or Duplicate node, once discovered identify the source something like patch:source="Sitecore.Buckets.config"> on the end.
Sitecore-Desktop-Database-selection-shows-duplicate-or-non-existent-database-img-1

Found the duplicate entry from a invalid patch.
Sitecore-Desktop-Database-selection-shows-duplicate-or-non-existent-database-img-2

Lets fix the patch file to update the attributes and not to add a duplicate entry.

Ref:
https://sitecore.stackexchange.com/questions/19661/sitecore-desktop-database-selection-shows-non-existent-database