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: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
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 @ 7:50 AM
Points: 489, Visits: 1,783
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: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
..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 @ 7:50 AM
Points: 489, Visits: 1,783
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: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
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: Friday, August 29, 2014 2:37 PM
Points: 239, Visits: 1,226
Is it using an application role?
Post #1551851
Posted Friday, March 21, 2014 9:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, August 18, 2014 8:25 AM
Points: 1,519, Visits: 2,550
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