Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Login not mapped to database is able to connect and work on that database.. Expand / Collapse
Author
Message
Posted Tuesday, December 17, 2013 5:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 19, 2016 9:59 PM
Points: 1,969, Visits: 3,154
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.
Post #1523617
Posted Tuesday, December 17, 2013 5:26 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 753, Visits: 2,989
Does it have a sysadmin Server Role?

Post #1523619
Posted Tuesday, December 17, 2013 5:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 19, 2016 9:59 PM
Points: 1,969, Visits: 3,154
..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.
Post #1523622
Posted Tuesday, December 17, 2013 6:48 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 9:27 AM
Points: 753, Visits: 2,989
No, it shouldn't have, you're right. The database is online, is it? (Sorry, I'm clutching at straws a bit!)
Post #1523665
Posted Tuesday, December 17, 2013 7:45 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 19, 2016 9:59 PM
Points: 1,969, Visits: 3,154
Yes it's online and the login is able to use the database too...
Post #1523691
Posted Monday, March 17, 2014 11:18 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 12:19 PM
Points: 585, Visits: 2,458
Is it using an application role?
Post #1551851
Posted Friday, March 21, 2014 9:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, August 19, 2016 9:59 PM
Points: 1,969, Visits: 3,154
Is it using an application role?


Nope.. It was connected as guest user :) .
Post #1553550
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse