See what GPO is applied to your machine and user

hello,

to see which GPO is apploed to your machine/user, you can use following commands inside the terminal:

  • check your GPO applied for your user:

    # gpresult /scope user /r
  • check the applied GPO for the machine:

    # gpresult /scope computer /r

Please note that you can get an "access denied." message when querying the machine GPO. Use a terminal with elevated rights to do this. E.g. execute the command-line as admin.

To view the applied values in your GUI you can use the tool rsop.msc

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.