WSUS Database Maintenance

Step 1 Connect to SQL management studio and connect to SUSDB\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\queryCopy below script and change the adminname parameter to your user name and parameter (@adminName=N’domain\user) Step 2 Step 3 Step 4 Step 5 Run the normal Server Wizard from the WSUS Management Console. Optional Automation If you’d like to automatically run the WSUS maintenance tasks, refer to … Read more

Redirect all HTTP to HTTPS in IIS

create a host wide redirect using IIS Manager. Select URL Rewrite, Add Rule(s)…, and Blank rule. Name:Redirect to HTTPS Match URLRequested URL: Matches the PatternUsing: WildcardsPattern: *Ignore case: Checked ConditionsLogical grouping: Match AnyCondition input: {HTTPS}Check if input string: Matches the PatternPattern: OFFIgnore case: CheckedTrack capture groups across conditions: Not checked Server VariablesLeave blank. ActionAction type: RedirectRedirect URL: https://{HTTP_HOST}{REQUEST_URI}Append query string: Not checkedRedirect type: Permanent (301) Apply the rule and run IISReset (or … Read more

Synchronizing your computer’s clock to a time server

From an administrative command prompt To poll an ntp server for time: NTP GPO details explained So what all these settings mean. Configuring Windows NTP Client: Enabled NtpServer: Here you specify which NtpServers to use seperated by a space but also with a special NTP flag. I decided to use the public ntp.org pools:0.se.pool.ntp.org,0x1 1.se.pool.ntp.org,0x1 2.se.pool.ntp.org,0x1 … Read more

WSUS 2012 fix for 2008R2 clients

The file wsus3setup.cab is missing for requesting Clients. I have a Workaround to fix it: Ive searched for the wsus3setup.cab file on my wsus 2012 Server and found the following search result Then I’ve copied it to the self created Folder Win7SP1 under: C:\Program Files\Update Services\SelfUpdate\WSUS3\x64 Windows update error 0x80244010, means WU_E_PT_EXCEEDED_MAX_SERVER_TRIPS and happens when a … Read more

Reinstalling WSUS

Install-WindowsFeature -Name UpdateServices-Services,UpdateServices-DB -IncludeManagementTools You can get away with not uninstalling WSUS entirely. Stop the related services, delete the DB and run the post-install. .\wsusutil.exe postinstall SQL_INSTANCE_NAME=”DC1\SQL2008″ It’s also recommended to delete the MMC console data as that can sometimes prevent the postinstall from creating the database. This can be found here: Try removing the … Read more