Install SQL Server without reboot

When installing SQL Server 2012 one can run into “‘Reboot required check failed” situation. This is in many production environments a total no-go. Here is a simple workaround for that:

  • open the windows registry editor 
  • find HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager
  • rename temporarily PendingFileRenameOperations to PendingFileRenameOperations-BAK
  • install SQL Server
  • when install finished, rename it back.

There you go… SQL Server installed without a reboot.

Corrupted roaming profile Windows 7

Hello,

we encountered several users getting temporary profiles when logging in to the domain controller (Windows Server 2008). The fix was quite simple, at least it work for our accounts. No garantee this will work for you.

  1. Delete the user account from your windows desktop machine.
    Computer -> System Properties -> Advanced System Properties -> User Profiles
  2. Delete user folder from disk
    Computer -> C: -> Users
  3. Access roaming profile on server and delete NTUSER.DAT, NTUSER.INI and NTUSER.POL
  4. Restart desktop client

Next login worked like a charm and the temporary profile was gone.

Clean RDP temporary licenses (Windows 2008 R2)

RDP (Remote Desktop) temporary per client licenses will only be created the first time a client logs in. In general they have a 90 days validity period, after which, if no real certificate is issued, the client access is going to be denied. If you have no problem with re-creation of theses temporary certificates for your client and only use these, it's quite simply to renew every certificate for RDP.

Simply open the command-line (cmd) and do:

  • net stop "Remote Desktop Licensing"
  • del /Q c:\windows\system32\lserver\*
  • net start "Remote Desktop Licensing"

That should be it. All certificates are gone and a new database will be created as soon as the first user logs in. To empty your database on a regularly basis, just create a batch file and let it run every month.