December 17, 2013 at 5:25 am
Experts,
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.
December 17, 2013 at 5:26 am
Does it have a sysadmin Server Role?
December 17, 2013 at 5:29 am
..had checked that as well.. No it doesn't have sysadmin.
It has only Public.
Otherwise that error shudn't have appeard too rite ?
Thanks for the quick response.
December 17, 2013 at 6:48 am
No, it shouldn't have, you're right. The database is online, is it? (Sorry, I'm clutching at straws a bit!)
December 17, 2013 at 7:45 am
Yes it's online and the login is able to use the database too...
March 17, 2014 at 11:18 am
Is it using an application role?
March 21, 2014 at 9:37 am
Is it using an application role?
Nope.. It was connected as guest user 🙂 .
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply