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

18470 for a disable login Expand / Collapse
Author
Message
Posted Thursday, December 26, 2013 9:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 9:33 AM
Points: 157, Visits: 1,178

I have a login which I had disable because to my knowledge it's not be use any more however my log & Event Log keeps filling up with the message "Login XXX failed for user, account is disable Error message 18470". Is this account being used in some other process/schedule job? I've check all the jobs on the server and they do not reference that login or nor any of the jobs are the owner of that login. What could be the reason why I'm kept getting that error message. Should I just delete the login instead of disable it.
Post #1525985
Posted Thursday, December 26, 2013 6:28 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, May 22, 2014 7:04 AM
Points: 1,688, Visits: 8,766
Better use profiler to find out the login source. You may also check default trace files to check the program name from where its originating.
Post #1526071
Posted Friday, December 27, 2013 8:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 9:33 AM
Points: 157, Visits: 1,178
Good Suggestion.
Post #1526172
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse