disable complexity check while creating user
-
hi friends How to disable password complexity check while creating a new user.here I am getting the error message " The password does not meet Windows policy requirements because it is not complex enough".I want to disable this check.I used the script "EXEC dbo.sp_grantdbaccess @loginame = N'name', @name_in_db = N'name'" for creating user. Thanks in advance thomas
-
hi friends How to disable password complexity check while creating a new user.here I am getting the error message " The password does not meet Windows policy requirements because it is not complex enough".I want to disable this check.I used the script "EXEC dbo.sp_grantdbaccess @loginame = N'name', @name_in_db = N'name'" for creating user. Thanks in advance thomas
You can't disable it. This is a policy that is enforced on either the server (the entire Windows server) or domain wide, not just SQL Server. There is no way to disable this policy just to add a user and turn it back on.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007, 2008