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 issue in Mgmt Console Expand / Collapse
Author
Message
Posted Monday, July 20, 2009 12:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 20, 2009 10:52 PM
Points: 3, Visits: 8
I Created one user and i assingned that user to one database, My DB Server have some more DB also, if i trying to login in SQL Server 2008 Mgmt studio.

The following Exception is throwing when i expand the database for every database.

The server principal "sUser" is not able to access the database "OtherDB" under the current security context. (.Net SqlClient Data Provider)


Note :It is populating the database when added the user to all other database by ddl deny roles.


Expected behaviour:
If i a user is created and assigned to some specific Database,When we login in Mgmt studio, it should display only the databases which is assigned to that user.

Please suggest howe to achieve the above Behaviour.

Post #755520
Posted Monday, July 20, 2009 2:15 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
Check to see that the user has 'connect' rights to the server and at least 'public' on the database in question.

Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #755580
Posted Monday, July 20, 2009 3:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 20, 2009 10:52 PM
Points: 3, Visits: 8
User (suser) having connect permission to the DB and public n db owner of database(db1)

Could you please tell me i have 10 databases on the server db1.....db10
i have 1 user db1user user.
i want db1 user should access only DB1. i have assigned the user as dbowner.... to my db1 database.
After login to the mgmt studio it is logging into dbserver, when i try to expand the Database from server Explorer,it is throwing the above exception.
but i can connect it from my application,but the problem is i am not able to open the database from management studio.
if i assign the user to all db with deny option and public .. to my db1 database then i can able to wrok in the management studio.
Post #755609
Posted Monday, July 20, 2009 3:22 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, March 4, 2014 10:03 AM
Points: 1,106, Visits: 1,334
Hey there,

Is the user sUser a SQL account or AD account and if so is it a member of any groups which could be registered with SQL and conflicting?

Regrading your app, can you be sure that the account being used to connect to SQL IS the sUser account? For example if you are connceting with local authentication (AD), this does not mean that there is not some underlying service (maybe on an app server) which isnt connecting to SQL with a different account.

If in doubt try with a completely new account (either AD or SQL) and then set up basic rights and work backward from there.


Adam Zacks

-------------------------------------------

Be Nice, Or Leave
Post #755616
Posted Monday, July 20, 2009 6:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 20, 2009 10:52 PM
Points: 3, Visits: 8
sUser is a SQL USer
Post #755691
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse