\nOK, I know this post doesn't really apply to most folks but I did want to have the setup instructions on my blog so that I could refer people to it. For the August release we updated all 17 labs and all of the demos for SQL Server 2008 RTM; however, we did use a "security enabled" VPC. And, well, security is bugging people right about now because the password policy in this VPC was set for 42 days. I know all of you run into this on production servers but on a test VPC, it's pretty much nothing more than an annoyance. So… I thought I'd mention how to disable it for the VPC.\n<\/p>\n
(1) <\/span><\/span><\/span><\/strong>Remove the policy for 42 password expiration<\/strong> <\/p>\n \n Local Security Policy Editor (Admin Tools, Local Security Policy)\n<\/p>\n \n Security Settings\n<\/p>\n \n Account Policies\n<\/p>\n \n Password Policy\n<\/p>\n \n Set the Maximum password age to 0 days (which is no password expiration<\/em><\/strong>)\n<\/p>\n (2) <\/span><\/span><\/span><\/strong>Change the SQLService account to not require a password on next login<\/strong> <\/p>\n \nComputer Management\n<\/p>\n \n Users and Groups\n<\/p>\n \n SQLService\n<\/p>\n \n Deselect<\/strong> the option "User must change password at next login"\n<\/p>\n \n you might not actually need to set this but it's good to check!<\/em>\n<\/p>\n (3) <\/span><\/span><\/span><\/strong>Windows Update<\/strong> <\/p>\n \nWhile you're at it then, you should also consider running Windows Update<\/strong>…\n<\/p>\n (4) <\/span><\/span><\/span><\/strong>Shutdown and save changes…<\/strong> <\/p>\n \nAnd, here's the full instructions that we usually give out at conferences\/workshops: SQL2008Aug HOLs DVD SETUP Instructions.pdf (25.93 KB)<\/a>\n<\/p>\n