I am logged into SQL Server Management Studio with an account that has access to multiple databases, but not
DB_123. As shown in the picture below, clicking to expand the "Databases" folder in the Object Explorer results in an error message.
I'm trying to follow instructions here and here to right-click on my database and export it that way. However, I cannot right-click on it because it won't show up in the Object Explorer. Yet I do have permission to query the database.
Is there any way to get the database(s) to appear in the Object Explorer or to otherwise dump the database(s) without using the Object Explorer?