Windows Server 2016 HP Server OEM bios lock

Recently I build a Hewlett Packard Enterpise (HPE) server for a customer . With the HP Proliant G9 server we ordered the HPE branded Server 2016 installation media. We wanted to virtualize the OS but when we booted the installation media the error “Failed BIOS Lock: This installation media may be used only on hardware manufactured by: Hewlett Packard Enterprise.” came up and the sytem rebooted.

To work-around this popup we need to simulate the host BIOS to the virtual machine. This can be done by adding the following line to the virtual machine VDMX file.

smbios.addHostVendor = “TRUE”

This can also be done in the GUI, in the advanced options of the virtual machine. See the screenshots below for the required setting.

After setting the option the virtual Windows Server 2016 installed succesfully.

Delen via: Facebooktwitterpinterestlinkedinmail

Microsoft App-V error ‘You do not have access to this information’ after installation

Recently after a fresh install of an App-V 5.1 environment I ran into an error managing the applications. When I browsed to the freshly installed App-V 5.1 management server I got the error ‘You do not have access to this information. Please Check your credentials‘. Even when the user / group was added to the App-V admin group.

AppVAdminError

After some research i discovered this was caused by the fact that the App-V management servers where not added to the App-V admin group. After adding the Active Directory computers accounts to the App-V management group the connection was working.

AppVgroup

Delen via: Facebooktwitterpinterestlinkedinmail

Basic Powershell commands

On this page some simple but useful Powershell commands are shown. These commands are the basics of the usage of Powershell.

To search all Powershell cmdlets for a keyword the ‘Get-Command’ command can be used. The ‘Get-Command’ can be abbreviated to ‘gcm’. To search for all commands that contain the word ‘network’ you can use the following commands.

gcm

Get-Command

It is also possible to serach within a specific module. To search in the NetTCPIP module the following command can be used:

Module

If you need to know more about a specific cmdlets you can use the ‘Get-Help’ command followed by the command you want to have more information about.

Get-Help

If you want to know the details of an cmdlet the ‘Get-Member’ command can be used. If you for example want to know what information can be shown with the ‘Get-Process’ command the following command can be used:

Get-Member

Within an output you can search for a specific value. To search for specific values you can use the ‘Where-Oject’ command. In this example we search for all processes named MMC.

Where-Object

The first thing the code is doing is getting a list of processes on our computer and passing the output (using the | character) to our Where-Object cmdlet. The cmdlet takes a script block as a parameter. The script block instructs the Where-Object cmdlets to only select objects where their name parameter is equal to ‘mmc’. The result is a list of the MMC instances that are running.

To stop all the instances of MMC that are running you can pipe the output to a ‘Stop-Process’ command.

Stop-Process

Delen via: Facebooktwitterpinterestlinkedinmail

Basic SQL commands

On this page some simple but useful SQL commands are shown.

Check all sysadmins on a SQL node:

Sometimes after a restore a login is not working, to fix use the following command:

Force take database offline:

ALTER DATABASE failed because a lock could not be placed on database error. If you get this error run the upper line and kill the SPID that is connected to the database.

Check open connections to databases

Check if full search is installed on SQL server

Delen via: Facebooktwitterpinterestlinkedinmail