How To: Auto-Logon to user account at startup with Windows Vista

1.Click on the Start button and type in ‘netplwiz‘. This will open the Advanced User Accounts menu.
2.In the Users tab, highlight the account you want to login to Vista automatically with, and then untick ‘must enter a username and password to use this computer’
3.Click on ‘Apply’. A new window will now popup asking you to enter the password of the account you’ve just highlighted. Do this, and then click ‘Ok’
4.Click ‘Ok’ on the Advanced User Accounts menu to finish

SQL Server 2008 setup support rules restart computer

1. Run “regedit” under program->run.
2. Navigate to:

"HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager"

3. Double-click on the key “PendingFileRenameOperations” and clear its content or if there are command that should be run copy it to a file then replace it after you finish sql setup. Press “Ok”.
4. Now click on “Re-run” in “Setup Support Files” window & it should pass.