Strange issue. I have an sql login and it's NOT mapped to a particular database.
But I am able to connect to that database and do the things with that login. How's that possible ?
When I check the properties of login, it throws the error "one or more databases are inaccessible and will not be displayed" and that database is unchecked. Any idea ?
The database is NOT in READONLY mode.