Can't Dump Database Because MS SQL Server Management Studio Won't Show Any Databases If 1 Is Permission Denied
One thing you can do, if you need both the data and schema, is script out a backup of the database instead of trying to use the UI in SSMS. You can find how to do that in the MS Docs: Create a Full Database Backup - Using Transact-SQL.
This is the T-SQL example from the above docs using your database name, for reference:
USE DB_D002;
GO
BACKUP DATABASE DB_D002
TO DISK = 'c:\backup folder\DB_D002.bak'
   WITH FORMAT,
      MEDIANAME = 'SQLServerBackups',
      NAME = 'Full Backup of DB_D002';
GO

Note if you run into the &quot;Operating system error 5(Access is denied.)&quot; error, then likely the file path you provided to the &quot;TO DISK&quot; option in the query does not provide write access to the SQL Server Service account (in Windows), and you can provide a different path that does or follow this StackOverflow on how to fix it for the specified path.