October 30, 2009 at 9:09 am
When I transferred my logins from one Sql 2005 to another, I failed to change a setting in the script & now all my logins have "Enforce Password Policy" on. Any way to Alter all Logins to change this setting to off/unchecked.
October 30, 2009 at 9:23 am
jude-32296 (10/30/2009)
When I transferred my logins from one Sql 2005 to another, I failed to change a setting in the script & now all my logins have "Enforce Password Policy" on. Any way to Alter all Logins to change this setting to off/unchecked.
May require a bit of work but you should look at ALTER LOGIN in BOL (Books Online). This may be where a cursor is useful, but it could be done without one with a little extra work.
October 30, 2009 at 10:18 am
One item that you may run into since I had something similar happen recently - turning the enforce password policy off didn't undo the "must change password at next logon" flag - I ended up having to reset the password to the same value so the user could log in. It may have been because they had already tried to log in and were locked out at the time, so your mileage may very. Of course, I only had to do 1, and I knew the password, not all the logins on the server. I know this isn't helpful in getting a solution, but it is something you can watch for as you are building the solution.
Chad
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply