Password validation failed. The password does not meet Windows policy requirements because it is not complex enough.

without going into the server, with TSQL is it possible to check the password policy?

I am creating like
CREATE LOGIN jimw WITH PASSWORD='JimWengerTesting-18:00' and still says it is not complex enough.. any thoughts on that?

thanks
LVL 6
anushahannaAsked:
Who is Participating?
 
chapmandewConnect With a Mentor Commented:
i missed that you already had WITH...my fault

CREATE LOGIN jimw WITH PASSWORD='JimWengerTesting-18:00'
, check_policy = off
0
 
chapmandewCommented:
CREATE LOGIN jimw WITH PASSWORD='JimWengerTesting-18:00'
with check_policy = off
0
 
anushahannaAuthor Commented:
thanks for the idea.

0
 
anushahannaAuthor Commented:
still getting
Incorrect syntax near '='.
0
 
anushahannaAuthor Commented:
excellent. Thank you.
0
All Courses

From novice to tech pro — start learning today.