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

Chris

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@discussion
s.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 r
unning 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@hotmai
l.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@discussion
s.microsoft.com> wrote in message
> news:OuHRoSVHHHA.1264@TK2MSFTNGP03.phx.gbl... 
>
>

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@discussion
s.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 runnin
g SQL2005 that logs the
> event. Is that because its SQL2005 that is checking the policy?
>
> Thanks
>
> Chris
>
> "Tibor Karaszi" <tibor_please.no. email_karaszi@hotmai
l.nomail.com> wrote i
n message
> news:ujIo5aVHHHA.2232@TK2MSFTNGP02.phx.gbl... 
>
>