SQL DBA learning curve

Error :

User account restriction. Possible reasons are blank passwords not allowed, logon hour restrictions, or policy restriction has been enforced

First and foremost ::

please check whether PASSWORD for the ACCOUNT is expired ? if so please reset it and try again  (before going ahead with below steps)

Solution::

1. Click the Start button and type gpedit.msc in the Search programs and files bar and hit enter.
2. At the left pane, go to Local Computer Policy > Computer Configuration > Windows Settings > Security Settings > Local Policies > Security Options
3. Look for “Accounts: Limit local account use of blank passwords to console logon only” and double click on it.
4. By default the Enable option is selected and all you need to do is select “Disable” and click OK.

Now you can connect to the computer using Remote Desktop and login to the user account that don’t have a password. Some Windows such as the XP home doesn’t have gpedit.msc and you will have to make the changes from registry.

1. Type regedit at the Search programs and files bar and hit enter.
2. Navigate to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
3. Look for LimitBlankPasswordUse name on the right pane, double click on it and set the value data to 0.

REF :: http://www.top-password.com/blog/how-to-fix-logon-failure-user-account-restriction/

OR

go to run type regedit.exe
then go here HKLM\System\CurrentControlSet\Control\Lsa\limitblankpassworduse
change from 1 to 0

REF::http://social.msdn.microsoft.com/Forums/en-US/iewebdevelopment/thread/6b65866a-10cc-42c8-8277-c9d9cd6c8afe

ENjoy:)