I have the following problem when I open SQL Server Management Studio and want to access the .... Database.
As you have seen before, this problem does not occur when i log in as an administrator.
Database is present in SSMS.
When I click on the “+” to open the tables, Views, .... I get the following message:
The Database ...... is not accessible. (ObjectExplorer).
When I create a query in SSMS with the following statement: USE database then i get the error The server principal "DESKTOP-BBB7SSS" is not able to access the database "....." under the current security context.
I understand the error but I don't know how and where to fix it.