showing all posts
by lunarg on July 12th 2018, at 09:47
When creating a SQL Server maintenance plan, the owner of the plan is set to the user logged in when the plan is created. If another user makes changes, the owner does not change. Sometimes it may become necessary to change the owner (e.g. if the owner's account is being disabled or removed). You can manually change the owner through the SQL Server Agent's Job Activity Monitor but changing it there is only temporary: changes to a maintenance plan will reset the owner back to the original one. Changing the owner from within the maintenance plan is not possible through the GUI, but there is a way to make the change through T-SQL statements.

The following queries need to be run against the msd  ...
by lunarg on July 10th 2018, at 14:46
A few steps to enable management of your Office 365 subscription using Powershell. One uses Powershell because not all configuration is available through the Office 365 Portal, and it's also useful for automation.

Note that the old method of installing the Azure Active Directory Module is deprecated. The only supported way is to install the cmdlets directly through Powershell, as described below.

UPDATE (2018-07-09): removed all deprecated information.

UPDATE (2016-04-20): updated links and information.

Download and install the Microsoft Online Services Sign-In Assistant.

Download and install Windows Management Framework 5.1.

Open an elevated Powershell, and run the following comma  ...
by lunarg on July 9th 2018, at 14:32
If you are using multi-factor authentication, it is not possible to use the old method of connecting to Exchange Online. You will have to install the Exchange Online Remote PowerShell Module, and use the Connect-EXOPSSession cmdlet to connect.

You can install the PowerShell module by following these instructions:

Log on to Exchange admin center.

In the left menu, click on hybrid.

Click the configure button for the Exchange Online Remote PowerShell Module. This will start the installation.

In the Application Install that appears, click the Install button.

A shortcut will be placed on your desktop which will start PowerShell with the required modules.

Start Exchange Online Remote PowerS  ...
by lunarg on July 9th 2018, at 14:30
You can manage Exchange Online through Powershell in a similar fashion as you would an on-premise Exchange. There are some differences between available cmdlets and what they do between on-premise Exchange and Exchange Online, but the majority are the same.

Using multi-factor authentication
The method mentioned below is deprecated and only works for non-MFA usage. If you are using multi-factor authentication, you will have to use the Exchange Online Remote PowerShell Module to connect to Exchange Online. Instructions can be found in this article.

Using PS remoting, the cmdlets for Exchange Online are imported through the internet, so first, you need to change the Powershell execution polic  ...
by lunarg on July 3rd 2018, at 14:58
When using VMware vConverter Standalone 6.1 or newer, performing a P2V may fail very early in the process with the following error:

FAILED: A file I/O error occurred while accessing ''.

You can work around the issue by enabling Use proxy mode on the Destination System page at the conversion wizard. As an alternative workaround, perform the P2V directly to a ESX host.

The reason for the error has to do with the ESX host's certificate not being trusted when performing a P2V to a vCenter.

If the Use proxy mode does not resolve your issue, please check whether the FQDN of the ESX host is resolvable on the machine running vConverter. Even when using strictly IP addresses, the FQDN still  ...
by lunarg on June 18th 2018, at 12:17

The actual serial number of a Barracuda NG Firewall can be obtained remotely in two ways:

  • Log on locally using NGAdmin and read the serial number from the dashboard. The serial number shown there is the actual serial number, and not the configured serial number.
  • Log on locally using SSH and run hwtool -s will also display the actual serial number.
by lunarg on May 29th 2018, at 19:11

A very useful guide on how to download specific files (such as older versions of games) on Steam:

by lunarg on May 2nd 2018, at 15:43
After performing actions which causes the SID to change (such as sysprep or a DC promote/demote), when opening an existing task in the task scheduler, you may encounter the following error:

Task Scheduler
General page initialization failed.
The specific error is:
"0x8007000d: The data is invalid." An error has occurredattempting to retrieve task account information.
You may continue editing the task object, but will beunable to change task account information.

As a result, it is also not possible to view or change the account information for the selected task.

To work around the issue, remove a saved RSA key, which has been invalidated with the change:

Stop the Task Scheduler s  ...
by lunarg on April 3rd 2018, at 13:38

DellEMC offers a free-to-try virtual appliance of DataDomain, allowing you to do a Try & Buy. You can download the appliance here:

by lunarg on March 22nd 2018, at 16:34
On a fresh install of Windows Server 2012R2, not joined to a domain, the first network connection (obtained through DHCP) is always treated as a Public network. Normally, when joining a domain, the network connection then becomes a Domain network, but if the server will not be joined to a domain, you probably will want to set it to Private. Unfortunately, the Public Network link in Network Center is not clickable, and thus, cannot be changed. But you can make the change anyway through the Local Security Policy.

Through Powershell (preferred method):

Look up the name of the network interface (e.g. "Local Area Connection") in the network adapters list.

Open an elevated Powershell   ...
by lunarg on March 12th 2018, at 12:01

A very useful blog article about killing active sessions to a compromised Office 365 account:

by lunarg on March 12th 2018, at 08:27

Starting from Windows 10 Creators Fall Update, you can use VT escape sequences to colorize the output to console. You can use this to colorize columns in Format-Table, too.

A sample snippet, colorizing the output based on the contents of the "Status" field:

$somelist | FT FirstName,LastName,@{l="Status";e={
    switch ($_.Status) {
        "OK" {$color = 92; break}
        "NOT OK" {$color = 91; break}
        default {$color = 93}

A complete list of color codes can be found here:

by lunarg on February 23rd 2018, at 11:19
When opening the EMC or EMS on an Exchange 2010 server, you may encounter this error:

The attempt to connect to http://server.domain.local/Powershell user 'Kerberos' authentication failed: Connecting to remote server failed with the following error message: The WS-Management service cannot process the request. The system load quota of 1000 requests per 2 seconds has been exceeded. Send future requests at a slower rate or raise the quota for this user. The next request from this user will not be approved for at least X milliseconds.

To workaround the issue, perform a restart of IIS: open an elevated command prompt and run:

iisreset /restart

After the restart, you will be able to log  ...
by lunarg on February 12th 2018, at 13:36
When starting up SQL Server or Analysis Services on Server 2012, you may encounter errors in the Application event log, even though SQL Server itself seems to operate normally:

ESENT error 1032
sqlservr (3472) An attempt to open the file "C:Windowssystem32LogFilesSumApi.log" for read only access failed with system error 5 (0x00000005): "Access is denied. ". The open file operation will fail with error -1032 (0xfffffbf8).

These errors are logged due to insufficient permissions for the service startup accounts for SQL Server and Analysis Services when the services access the following folder for logging as a part of the Software Usage Metrics feature: C:\Windows\System32\  ...
by lunarg on February 9th 2018, at 10:03

HP 1920 switches (and others of the same kind) have a CLI mode which is highly restricted. It is possible to unlock this, providing full access to the configuration of the switch through CLI.

Log on to the CLI (SSH or Telnet) with the admin user and the password (default: none).

Type and press Enter:

_cmdline-mode on
All commands can be displayed and executed. Continue? [Y/N]

Press Y to confirm.

Please input password:

Enter the password. This is a firmware-set password and is not user-defined. Depending on the firmware, try one of these:

  • 512900
  • Jinhua1920unauthorized

If successful, you can now run all commands.

by lunarg on January 30th 2018, at 10:40

You can easily update your vCenter Server Appliance (VCSA) offline by downloading a product patch ISO and via the CLI.

Download the latest patch from VMware Patch Download Center. Select VC from the Search by Product drop-down menu, then select the correct version (i.e. 6.0 or 6.5). Download the patch ISO and attach it to the VCSA.

Log in to the shell (using SSH or VMRC) and initiate the update:

  1. Stage the ISO updates:
    software-packages stage --iso
  2. Optionally, you can view the list of packages to be updated:
    software-packages list --staged
  3. To install the updates, run:
    software-packages install --staged

After the update has finished, you will have to reboot the VCSA.

by lunarg on January 17th 2018, at 11:29

You can use either esxcli or vicfg-hostops to enter/exit maintenance mode.


  • Enter: esxcli system maintenanceMode set --enable true
  • Exit: esxcli system maintenanceMode set --enable false


  • Enter: vicfg-hostops --operation enter
  • Exit: vicfg-hostops --operation exit

Note that you can use vicfg-hostops --operation info to check whether the host is finished with entering maintenance mode or is still busy.


After connecting to the host or vCenter server:

  • Enter: Get-VMHost <name-of-host> | Set-VMHost -State Maintenance
  • Exit: Get-VMHost <name-of-host> | Set-VMHost -State Connected
by lunarg on January 17th 2018, at 11:10
When attempting to register the vSphere Replication appliance to the PSC, you may encounter this error:

Server returned 'request expired' less than 0 seconds after request was issued, but it shouldn't have expired for at least 600 seconds.

On the appliance, look in the log file /opt/vmware/hms/logs/hms.log: if you see messages similar to the following, the time of the replication appliance and the PSC may not be in sync.

2017-01-14 06:57:00.694 ERROR com.vmware.vim.sso.client.impl.SoapBindingImpl [main] (..client.impl.SoapBindingImpl) | SOAP The time now Wed Jan 18 12:27:31 MST 2017 does not fall in the request   ...
by lunarg on January 15th 2018, at 14:12
In environments which have migrated from Exchange 2010 to 2013 (or later), and where public folders have been decommissioned, you may encounter the following events in the Application event log:

MSExchange ADAccess, Event ID: 2937
Process MSExchangeTransport.exe (PID=9356). Object [CN=Contoso,CN=Microsoft Exchange,CN=Services,CN=Configuration,DC=contoso,DC=com]. Property [RemotePublicFolderMailboxes] is set to value [ Objects/PublicFolderMailboxDEL:d980f9a4-2014-4165-aad0-7ab91b35ef01], it is pointing to the Deleted Objects container in Active Directory. This property should be fixed as soon as possible.

With the removal of the public folders database, not all objects re  ...
by lunarg on January 10th 2018, at 14:28
Internet Explorer 11 has an integrated Adobe Flash Player plugin, but on Windows Server 2016, this plugin is not active by default. In fact, checking the available plugins within IE does not show the plugin as installed. This is because the plugin is not activated by default (which is somewhat logic as it's considered a security risk).

The package containing the plugin does exist on Windows Server 2016 (with GUI) but is not active. You can manually activate the plugin through dism:

dism /online /add-package /packagepath:"C:\Windows\servicing\Packages\Adobe-Flash-For-Windows-Package~31bf3856ad364e35~amd64~~10.0.14393.0.mum"

After adding the package, you will have to reboot for it  ...
showing all posts