Expired account

[tiz]

The following error keeps occurring every 30 minutes in error logs. "The specified user account has expired".

Has anyone ever come across this error message?

[skhanal]

Describe your environment.

Sounds like some automated process is trying to connect to the server every 30 minutes and login has expired. Is it windows login?. Check with your windows admin to see if it is expired.

[tiz]

I am using SQL Server 2005 which has various servers and one particular server is rans various jobs at different times, e.g every 1min, 10 min, 30min etc...

The particular object that is failing is a service account and there also are no accounts that have expired.

[rmiao]

For which service? Is it domain account? Do you have completed error message? Did you check in ADS?

[tiz]

Here is the full error message.

Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 532
Date:
Time: 01:00:00
User: NT AUTHORITY\SYSTEM
Computer: Computer name
Description:
Logon Failure:
Reason: The specified user account has expired
User Name:
Domain:
Logon Type: 3
Logon Process: Authz
Authentication Package: Kerberos
Workstation Name: Workstation name
Caller User Name: SQLserver
Caller Domain: Domain name
Caller Logon ID: (logon id)
Caller Process ID: ProcessID
Transited Services: -
Source Network Address: -
Source Port: -

[rmiao]

Did you double check the account in ads?

[tiz]

I checked in AD and there are no accounts that have expired.

[skhanal]

Check if date is off on your SQL Server.

Do you use SSL certificate on it?. If yes check if certificate has expired.

[rmiao]

Are you talk about 'NT AUTHORITY\SYSTEM'? This is local system account.