Policy Server crashes during authentication attempt

Document ID : KB000050297
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The Policy Server crashes and restarts whenever a user tries to authenticate.

The Event Viewer information during the error is:

Faulting application name: smpolicysrv.exe, version: 12.0.303.363, time stamp: 0x4d956fa8
Faulting module name: MSVCR80.dll, version: 8.0.50727.4927, time stamp: 0x4a2752ff
Exception code: 0xc000000d
Fault offset: 0x000489bc
Faulting process id: 0x11f0
Faulting application start time: 0x01cc3a38708d45ab
Faulting application path: D:\PROGRA~1\CA\SITEMI~1\bin\smpolicysrv.exe
Faulting module path: C:\Windows\WinSxS\x86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.4927_none_d08a205e442db5b5\MSVCR80.dll
Report Id: b3e104eb-a62b-11e0-879c-005056201e6c

Authentication uses the SQL Queries.

Solution:

The SQL Query configured was like the following:

select Name from SmUser where Name = %s and InternalUser = 0 and HasLoggedIn=0 and Password = HASHBYTES ( SHA1 , Name + %S + PasswordSalt) and LoginExpiryDate > GetDate()

The SQL Query HASHBYTES does not support the flag %S.

To resolve the crash, change the %S by lowercase %s.