Tag: Windows

WSUS won’t uninstall or re-install

  • WSUS 3.0 SP2 is missing SQL server Express or has been damaged somehow.
  • When opening WSUS you receive a SQL error when trying to connect.
  • You cannot uninstall WSUS. An attempt to uninstall/re-install fails with an error.
  • The event log shows event id: 1034 with “Removal success or error status: 1603”

HOW TO FIX:

  1. Open REGEDIT in and locate: HKLM\Software\Microsoft\UpdateServices\ServerSetup.
  2. Change the value of “wYukonInstalled” to 0x0 (zero) and ensure that the value of “SqlInstanceIsRemote” is oxo [hexa] (zero) [decimal].
  3. Download and run the WSUS 3.0 SP2 installer. You should now be able to remove the product using the installer. Select none of the check boxes (to remove database, logs or updates), we can remove these manually later.
  4. Run the WSUS 3.0 SP2 installer again and (this time it should allow you to install). Install the Full product including management console.
  5. Select the option to use an existing database server.
  6. It should find the Internal Database you installed and configured.
  7. Step through the WSUS configuration wizard.

TCP Settings for Heavy Load on Windows OS

This topic describes how to tune Windows XP, Windows 2003, and Windows 2008 /2012 R1 & R2 operating systems for TCP/IP performance. “Tuning” involves adding several registry keys. To add a key to the registry, you can either edit it directly as described below. When you have finished adding or editing these registry keys, you must restart the Server.

In all versions of Windows, add the keys described below. Certain keys/values depend on the operating system installed (noted in the Value name column where different).

Subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\TCPIP\Parameters

Value Name
(DWORD 32-bit)		 Value Data
Decimal)		 Description
TcpTimedWaitDelay 30 This key determines the time that must elapse before TCP/IP can release a closed connection and reuse its resources. This interval between closure and release is known as the TIME_WAIT state or twice the maximum segment lifetime (2MSL) state. During this time, reopening the connection to the client and server costs less than establishing a new connection. By reducing the value of this entry, TCP/IP can release closed connections faster and provide more resources for new connections. Adjust this parameter if the running application requires rapid release, the creation of new connections, or an adjustment because of a low throughput caused by multiple connections in the TIME_WAIT state.
MaxUserPort 32768 (minimum) This key determines the highest port number that TCP/IP can assign when an application requests an available user port from the system.
TcpMaxDataRetransmissions 5 (seconds) This key determines how many times TCP retransmits an unacknowledged data segment on an existing connection.
TcpNumConnections 16777214 Determines the maximum number of TCP connections that can be open simultaneously. If the value is 0, you cannot open a connection.