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 status Expand / Collapse
Author
Message
Posted Saturday, November 17, 2012 11:57 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, November 21, 2014 5:22 PM
Points: 1,790, Visits: 3,252
for sql server logins, there is a property menu of status that I can disble the login, and deny permission to connect to database engine.

What does it mean: when a login is disabled. or denied .

Can the user can still connect to the database?

I have a SSRS report, data source is setup to connect to db using this user account , I found even I disabled the login, it can still connect to the database.

Thanks
Post #1385971
Posted Sunday, November 18, 2012 3:18 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, November 24, 2014 3:46 AM
Points: 709, Visits: 1,442
What connection does sp_who2 show is connecting to the SSRS database?

Joie Andrew
"Since 1982"
Post #1386034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse