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

inaccessibility of DB for a certain user Expand / Collapse
Author
Message
Posted Thursday, September 05, 2013 5:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, October 21, 2013 4:15 AM
Points: 6, Visits: 18
The trouble is:
We have an instance, there are several databases. We have a login (uses Windows authentication, lets call it 'DOMAIN\user'), which is mapped to several DBs as public. When connecting to server under that login you can view all of these DBs except one. When trying to access this one, the error pops up 'Database is not accessible'. Under other logins it is accessible, and our 'DOMAIN\user' is mapped to it, has rights to connect to it (watched in permissions of DB), I even tried and made him datareader.
No luck(
sp_helplogins shows, that he is user in this DB, and has several role memberships.
I tried to drop him and create again - still got the problem. The interesting thing is that there are users with identical rights, who can connect to DB. Any ideas/suggestions?
Post #1491724
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse