Event 697 on SQL2005 Servers

Hi,
We are seeing a tremendous amount of event 697 for the Account Management
category in Event Viewer Security on our SQL2005 servers. This seems to be
mainly for the account running MS SQL Server. The description is
Password Policy Checking API is called:
Any ideas why?
Thanks
ChrisYou've probably created SQL Server logins for which you specified SQL Server to enforce the password
policy specified in Windows.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:OuHRoSVHHHA.1264@.TK2MSFTNGP03.phx.gbl...
> Hi,
> We are seeing a tremendous amount of event 697 for the Account Management category in Event Viewer
> Security on our SQL2005 servers. This seems to be mainly for the account running MS SQL Server.
> The description is
> Password Policy Checking API is called:
> Any ideas why?
> Thanks
> Chris
>|||That's right Tibor. Does it have to record so many entries? Is it one for
each time an SQL Login connects or runs a query against the server? Its
always the account running SQL2005 that logs the event. Is that because its
SQL2005 that is checking the policy?
Thanks
Chris
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:ujIo5aVHHHA.2232@.TK2MSFTNGP02.phx.gbl...
> You've probably created SQL Server logins for which you specified SQL
> Server to enforce the password policy specified in Windows.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
> news:OuHRoSVHHHA.1264@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> We are seeing a tremendous amount of event 697 for the Account Management
>> category in Event Viewer Security on our SQL2005 servers. This seems to
>> be mainly for the account running MS SQL Server. The description is
>> Password Policy Checking API is called:
>> Any ideas why?
>> Thanks
>> Chris
>>
>|||Yes, yes, yes and yes. :-)
I'm no Windows expert, so I suggest you check with Windows people if you can control whether Windows
is to log each of these occurrences.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
news:O$06vOXHHHA.1064@.TK2MSFTNGP04.phx.gbl...
> That's right Tibor. Does it have to record so many entries? Is it one for each time an SQL Login
> connects or runs a query against the server? Its always the account running SQL2005 that logs the
> event. Is that because its SQL2005 that is checking the policy?
> Thanks
> Chris
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in message
> news:ujIo5aVHHHA.2232@.TK2MSFTNGP02.phx.gbl...
>> You've probably created SQL Server logins for which you specified SQL Server to enforce the
>> password policy specified in Windows.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "Chris Wood" <anonymous@.discussions.microsoft.com> wrote in message
>> news:OuHRoSVHHHA.1264@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> We are seeing a tremendous amount of event 697 for the Account Management category in Event
>> Viewer Security on our SQL2005 servers. This seems to be mainly for the account running MS SQL
>> Server. The description is
>> Password Policy Checking API is called:
>> Any ideas why?
>> Thanks
>> Chris
>>
>>
>