Wednesday, March 7, 2012

CheckSAPwdPolicy Return=''28001''

I need help for the following problem:

We use SQL Server 2005 Express. With a Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) we get the following installation problem.

In the log-file SQLSetup0005_M067RT1107P1_SQL.log we get these lines:

...

Failed to validate sa password error 2704
<EndFunc Name='CheckSAPwdPolicy' Return='28001' GetLastError='0'>
Error Code: 0x80076d61 (28001)
Windows Error Text: Source File Name: sqlca\sqlcax.cpp
Compiler Timestamp: Fri Feb 9 22:35:05 2007
Function Name: SAPasswordPolicyCheck
Source Line Number: 2727
...

I try it on other PC a Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790) - Installation.

Here I got no problems!

What is the reason?

Thank you!

Seems that the first computer has a password policy enabled in Windows which is applied to the sa account (and all appropiate SQL accounts on the server). Either a Local Security Policy or a domain policy is applied to the server which sets the password complexity on the server. If your password is not conform to the complexity rules, the creation of the user will fail. (use the MMC snapin for configuration)

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Thank you very much for your help!

The problem is the local security policy!

No comments:

Post a Comment