December 6, 2008 at 2:55 am
Hi,
We have Win 2003 Server and I understand that CHECK_POLICY is ON by default when creating a login in SQL Server 2005. We don't want to change the policy in Windows 2003. Is there a way to change the default value of CHECK_POLICY? So that when our application creates a new user, password policy will not be enforced. Our application was written before SQL 2005. We're trying to avoid making any code changes in our app if there's a way to tweak SQL 2005 not to enforce password policy by default.
I've searched the web and I could not find any work around without resorting to use the new CREATE LOGIN command with CHECK_POLICY=OFF. Any help is appreciated.
Thanks/ng
January 25, 2012 at 12:00 pm
Did you ever get a reply for this? I have the same situation where I want to globally turn off the check authentication but can not find any information. Thx.
January 26, 2012 at 5:35 am
I have looked for this as well and have never found anything.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply