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.