dthillsr
asked on
Login Failed
I am getting a Failure Audit in the Application event log for a SQL database. I am not a DBA but know enough SQL to be dangerous. The errors occur on a database that is not used anymore. It is offline, if I put it online the errors go away. I would like to put the database back online but not have the errors. The error I keep getting about every minute is login failed for user domain\user [CLIENT xxx.xxx.xxx.xxx]. The severity is 14 and a state of 16 in the SQL log. The good database does not generate the errors for the user. My goal as stated earlier is no errors and the database generating the errors put back offline without generating the errors.
Please check for Automated Service of your computer (service which are started)
ASKER
I checked the Task Schedular and there are no tasks running that have anything to do with SQL server. All Automatic services are started and I deleted the one job that was there and recreated it for the correct database and I do not have anything showing up under Alerts.
In the audit log, is there an IP address associated with the failure.
(I'm just running through the checklist of possibilities, including someone's terminal.)
(I'm just running through the checklist of possibilities, including someone's terminal.)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If that doesn't work, check any tasks on the NT scheduler.