Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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: Yesterday @ 7:23 PM
Points: 1,500, Visits: 2,520
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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 449, Visits: 1,661
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: Yesterday @ 7:23 PM
Points: 1,500, Visits: 2,520
..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
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:40 AM
Points: 449, Visits: 1,661
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: Yesterday @ 7:23 PM
Points: 1,500, Visits: 2,520
Yes it's online and the login is able to use the database too...
Post #1523691
Posted Monday, March 17, 2014 11:18 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 17, 2014 7:31 AM
Points: 232, Visits: 1,193
Is it using an application role?
Post #1551851
Posted Friday, March 21, 2014 9:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 7:23 PM
Points: 1,500, Visits: 2,520
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