The Tech Journal

Run WSUS cleanup and index script on Windows Server Core without SQL Management Studio

Windows Server 2019, Windows Server Core, WSUS 8 Responses »

May 142019

You’re running WSUS (Windows Server Update Services) on Windows Server 2019 Server Core, and you want to run the WSUS Re-Index or WSUS Cleanup script, but you can’t because you cannot install the SQL Management Studio on Windows Server Core.

Well, there’s a way around this. To run SQL scripts on the WID (Windows Internal Database) on Windows Server Core, we’ll need to install “sqlcmd” (info here).

Now normally with Microsoft SQL, you’d simply connect remotely using the SQL Management Studio, and you can if you’re using fully blown Microsoft SQL Server with your WSUS implementation, however most of us aren’t. In most small deployments, WSUS is configured using WID (Windows Internal Database) which is essentially Microsoft SQL Express.

Microsoft SQL Express doesn’t support remote named pipe connections, and there’s no easy way to configure TCP connections with the registry editor, so the easiest way to accomplish executing SQL scripts is to install and use the “sqlcmd”.

Instructions

Install the SQLCMD command utility

First we need to identify the version of SQL express that’s running WID on the server running Windows Server Core 2019.
Open “notepad” and open the following file which containts the WID log.
```
C:\Windows\WID\Log\error
```

At the beginning of the log file, you’ll note the Microsoft SQL version that’s running. In my case it’s “Microsoft SQL Server 2014 (SP2-GDR)” specifically 12.0.5214.6 as shown below.

2019-05-14 10:52:47.79 Server      Microsoft SQL Server 2014 (SP2-GDR) (KB4057120) - 12.0.5214.6 (X64) 
	Jan  9 2018 15:03:12 
	Copyright (c) Microsoft Corporation
	Windows Internal Database (64-bit) on Windows NT 6.3  (Build 17763: ) (Hypervisor)

The “sqlcmd” is part of the Microsoft SQL Server Feature Pack, so a quick search of “SQL Server 2014 SP2 Feature Pack” returned the following URL:
https://www.microsoft.com/en-us/download/details.aspx?id=53164
When you click download, you’ll notice multiple files. Choose the ”
ENU\x64\MsSqlCmdLnUtils.msi” file to download.
Copy this file over to your server running Windows Server Core.
Execute and run the installer. Follow the prompts.
You’ll notice the installer will error and require “Microsoft ODBC Driver 11 for SQL Server”. A quick search finds this download:
https://www.microsoft.com/en-ca/download/details.aspx?id=36434
Download the above file, install the “Microsoft ODBC Driver 11 for SQL Server”.
Re-start the “MsSqlCmdLnUtils.msi” installer, and it should now complete.
You have now installed the SQLcmd utility.

Run the WSUS Re-Index Script

Download the WSUS Database Re-Index script from:
https://gallery.technet.microsoft.com/scriptcenter/6f8cde49-5c52-4abd-9820-f1d270ddea61
Copy the script to the server.

Run the following command from the command prompt:

sqlcmd -S np:\\.\pipe\Microsoft##WID\tsql\query –i C:\Folder\WsusDBMaintenance.sql

You’ve officially installed the sqlcmd and ran the WSUS Re-Index script on Windows Server Core. Congratulations!

Manage (Remotely) IIS on Windows Server 2019 Server Core

IIS, Microsoft 33 Responses »

May 142019

So you have a Windows Server 2019 running Server Core with no GUI installed, and you have installed and are using the IIS (Internet Information Services) role and would like to manage or modify IIS configuration.

Because Windows Server Core doesn’t have a full GUI, you cannot install or use the Internet Information Services (IIS) Manager on this server.

I originally had to figure this out so I could modify the “WsusPool” Application Pool on IIS on a Windows Server Core install that was hosting a WSUS Server to increase the Private Memory Maximum setting.

To manage, modify, or edit IIS configuration, you’ll need to use the IIS Manager on a different server/computer, and remotely connect to the IIS instance on Server Core. From here you will be able to edit/modify the server as much as you require.

Requirements

To do this, you’ll need the following:

Target: Windows Server with IIS role installed
Remote System with IIS Manager installed to connect to target

In my case the target is running Windows Server 2019 Server Core, however you can also use the instructions to enable access on the fully blown Windows Server installs as well.

Instructions

Follow these instructions to enable remote IIS management.

Log on to the target server.
Open PowerShell (by typing “powershell” at the command prompt) and install the Web Management Service with the following command.
```
Install-WindowsFeature Web-Mgmt-Service
```

Create a firewall exception (if needed) by running the following command in PowerShell.

netsh advfirewall firewall add rule name=”IIS Remote Management” dir=in action=allow service=WMSVC

Open the Registry Editor by running “regedit”.

Do either of the following:
Navigate to the following key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WebManagement\Server

Then set “EnableRemoteManagement” to “1” as shown:
Registry Modifcation of EnableRemoteManagement

Or save the below as a file.reg:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\WebManagement\Server]
"EnableRemoteManagement"=dword:00000001

And then import it using command prompt with the command:

reg import file.reg

Configure the Web Management Service to run on boot by running the following command in command prompt.
```
sc config WMSVC start= auto
```
Start the Web Management Service by running the following command in command prompt.
```
net start WMSVC
```
Open the “Internet Information Services (IIS) Manager” on the remote machine.
On the left pane, right click on “Start Page”, and select “Connect to a Server”.
Enter the server name or IP and click “Next”.
Enter the credentials and click “Next”.
Give the Connection a friendly name (I usually just leave it), and click “Finish”.
You may be prompted with a “Server Certificate Alert”. Click “Connect” to bypass it.
You now have the remote target IIS instance listed in the “Connections” pane. You can now manage the server.

Congratulations, you can now remotely manage your IIS instance running on Windows Server Core.

Rebuild Search Index Catalog on Microsoft Exchange 2016

Exchange Server, Microsoft 11 Responses »

May 142019

There may be a point in time where you may wish to clear and rebuild the search index catalog on your Microsoft Exchange 2016 Server. This will cause the server to rebuild the search index from scratch.

In my case, for the past month or so Outlook 2019 (Office 365) clients connecting to an on-premise Microsoft Exchange 2016 Server, have been seeing the message “We’re having trouble fetching results from the server…”. The user can click on “Let’s look on your computer instead.” and the search will complete.

When troubleshooting this issue, I tried all of the following:

Clearing and rebuilding the Search index on the client computers
Deleted the OST files to re-create the local cached copy on the client computers
Restarting the Exchange Server
Restarting the Client Computers
Analyzing the Event Log for any errors (none)

None of the above helped in troubleshooting.

We're having trouble fetching results from the server... — Outlook: “We’re having trouble fetching results from the server…”

Because of this, I decided to clear and rebuild the Search Index catalog for the mailbox database on the Exchange Server.

To check the status and to see if your index is corrupt, run the following command:

Get-MailboxDatabaseCopyStatus |  ft ContentIndexState

“ContentIndexState” will report as “Corrupt” if it is corrupt, or “Healthy” if it is healthy.

[PS] C:\Windows\system32>Get-MailboxDatabaseCopyStatus |  ft ContentIndexState

ContentIndexState
-----------------
          Healthy

My server reported as healthy, but I still chose to run the instructions below to rebuild the index.

Instructions

To do delete and re-create your Exchange Server Mailbox Database Search Index Catalog, please perform the following instructions.

Please Note: This is only for Exchange servers that are not part of a DAG. Do not perform these steps if your server is part of an Exchange cluster. Always make sure you have a complete backup of your server.

Log on to your Exchange server.
From the Start Menu, expand “Microsoft Exchange Server 2016”, and right-click on “Exchange Management Shell”, and select “Run as Administrator”.

Type the following commands to stop required search services.

Stop-Service MSExchangeFastSearch
Stop-Service HostControllerService

Open a file browser (you may need Administrative privilege) and navigate to your Exchange mailbox directory.
```
C:\Program Files\Microsoft\Exchange Server\V15\Mailbox\Mailbox Database NumberNumberNumber
```
You’ll see a folder inside of the mailbox folder with a GUID type name with Single at the end. Delete or move this (preferred is move to alternate location). I’ve put an example below.
```
12854239C-1823-8c32-ODJQ-SSDFK123CSDFG.1.Single
```
This is the folder you want to move/delete.
Go back to the “Exchange Management Shell”, and run the following commands to start the services.
```
Start-Service MSExchangeFastSearch
Start-Service HostControllerService
```
As mentioned above, you can check the status of the rebuild by running the “Get-MailboxDatabaseCopyStatus” command, and looking at the “ContentIndexState” status.

That’s it! After running the command, you may notice your server will experience heavy CPU usage due to Exchange rebuilding the search index.

After rebuilding the search index, I noticed that my Outlook clients were able to successfully search on the server without having to select “Let’s look on your computer instead.”.

WSUS IIS Memory Issue – Error: Connection Error

Microsoft, WSUS 23 Responses »

May 142019

On a fresh or existing WSUS install, you may notice that the WSUS Administrator MMC applet stops functioning and present the error “Error: Connection Error – An error occurred trying to connect to the WSUS Server.”

I originally experienced this on Windows Server Update Services running on Windows Server 2012 R2 and applied the fix. Recently, I deployed Windows Server Update Services on a new Windows Server 2019 – Server Core install, and experienced this issue during the first synchronization. Before realizing what the issue was, I attempted to re-install WSUS and IIS from scratch numerous times until I came across old notes. One would have thought they would have resolved this issue on a new server operating system.

When the issue occurs, all processes will appear to be running on the server. Looking at the server event log, you’ll notice multiple application errors:

Event ID: 13042 - Windows Server Update Services
Description: Self-update is not working.

Event ID: 12002 - Windows Server Update Services
Description: The Reporting Web Service is not working.

Event ID: 12012 - Windows Server Update Services
Description: The API Remoting Web Service is not working.

Event ID: 12032 - Windows Server Update Services
Description: The Server Synchronization Web Service is not working.

Event ID: 12022 - Windows Server Update Services
Description: The Client Web Service is not working.

Event ID: 12042 - Windows Server Update Services
Description: The SimpleAuth Web Service is not working.

Event ID: 12052 - Windows Server Update Services
Description: The DSS Authentication Web Service is not working.

Event ID: 12072 - Windows Server Update Services
Description: The WSUS content directory is not accessible.
System.Net.WebException: The remote server returned an error: (503) Server Unavailable.
   at System.Net.HttpWebRequest.GetResponse()
   at Microsoft.UpdateServices.Internal.HealthMonitoring.HmtWebServices.CheckContentDirWebAccess(EventLoggingType type, HealthEventLogger logger)

You will also see the below error message when attempting to use the WSUS MMC.

WSUS Connection Error presented when memory issue occurs — WSUS 503 Error: Connection Error

The Problem

This issue occurs because the WSUS application pool in IIS “WsusPool” has reached it’s maximum private memory limit and attempts to recycle the memory usage.

Ultimately I believe this causes the IIS worker process to crash since it has run out of memory, and the pending command (whether it’s a synchronization or something else) fails to complete.

Previously, I noticed database corruption on a WSUS SQL Express database when this issue occurred, so I recommend applying the fix on a fresh install of WSUS.

The Fix

To resolve this issue, we need to adjust the max

On the server running WSUS and IIS, open the “Internet Information Services (IIS) Manager” inside of the “Windows Administrative Tools” (found in the start menu, or Control Panel).
On the left hand side under “Connections”, expand the server, and select “Application Pools”.
On the right hand side under “Application Pools” heading, right-click on “WsusPool” and select “Advanced Settings”.
In the “Advanced Settings” window, scroll down until you see “Private Memory Limit (KB)”. Either change this to “0” (as shown below) to set no memory limit, or increase the limit to the value you prefer.
Select “Ok” to close the window.
Restart IIS by running “iisreset” from an administrative command prompt, restarting the server, or selecting “Restart” under “Manage Server” when looking at the default pane in IIS when the server is selected.

The issue should now be resolved and your WSUS server should no longer be crashing.

If you are applying this fix on a Server Core install, you’ll need to connect remotely to the IIS instance to apply the fix.

How to Enable SSH on ESXi Host Server via vCenter

ESXi, VMware No Responses »

May 082019

We’ve all been in the situation where we need to install a driver, vib file, or check “esxtop”. Many advanced administration tasks on ESXi need to be performed via shell access, and to do this you either need a console on the physical ESXi host, an SSH session, or use the Remote vCLI.

In this blog post, I’m going to be providing a quick “How to” enable SSH on an ESXi host in your VMware Infrastructure using the vCenter flash-based web administration interface. This will allow you to perform the tasks above, as well as use the “esxcli” command which is frequently needed.

This method should work on all vCenter versions up to 6.7, and ESXi versions up to 6.7.

How to Enable SSH on an ESXi Host Server

Log on to your vCenter server.
On the left hand “Navigator” pane, select the ESXi host.
On the right hand pane, select the “Configure” tab, then “Security Profile” under “System.
Scroll down and look for “Services” further to the right and select “Edit”.
In the “Edit Security Profile” window, select and highlight “SSH” and then click “Start”.
Click “Ok”.

This method can also be used to stop, restart, and change the startup policy to enable or disable SSH starting on boot.

Congratulations, you can now SSH in to your ESXi host!

Older Entries Newer Entries