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: Today @ 12:00 PM
Points: 1,774, Visits: 3,213
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: Tuesday, September 9, 2014 4:02 AM
Points: 709, Visits: 1,422
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