Author: kimconnect

Chocolatey Ignore Checksums

Issue: Certain choco packages may have mismatched signatures from its repo due to some minor…

How to Enforce Keyboard Layout Consistency for Remote Desktop

# The following function will allow the RDP session to store the user keyboard language…

GPO to Set NTP on Domain Joined Computers and Servers

As a precursor, please review this article to set NTP for PDC Emulator prior to…

Set NTP on Primary Domain Controller

Intro: Here is some general information to on the network time synchronization protocol (NTP) topic:…

Active Directory: Helpdesk Admins Group Creation

Why? Give your helpdesk team the ability to manage user accounts in the domain without…

An authentication error has occurred (Code: 0x80004005)

Symptom: [Window Title]Remote Desktop Connection[Content]An authentication error has occurred (Code: 0x80004005).Remote computer: 192.168.1.54[OK] Cause: This…

SQL: Microsoft Dynamics – Rebuilding a Database View Named ‘FilteredContact’

Why? Update: currently, I'm unable to rebuild this complex view due to SQL constraints. Hence,…

SQL Server: Use Profiler to Tune Database Indexes

Run Microsoft SQL Server Management Studio > Tools > SQL Server Profiler > Use the…

PowerShell: Set DNS Server IPs on Default Network Interface

$dns1=.{ Import-Module ActiveDirectory $fsmoRoles=Get-ADDomainController -Filter *|Select-Object Name, Domain, Forest, OperationMasterRoles|Where-Object {$_.OperationMasterRoles}|select Name,OperationMasterRoles $pdcServer=($fsmoRoles|?{'PDCEmulator' -in $_.OperationMasterRoles}).Name…

Some WSUS Troubleshooting Notes

Some errors and interpretations: 0x8024401c: networking generic error 0x80244022: downloading generic error     Check…

How to Migrate a Database to a Newer Version of Microsoft SQL Server

Get Version of new SQL server Create a sql-dump script on the old SQL server:…

PowerShell: Start IIS Sites & App Pools

Before running the below script, it's necessary to mark certain IIS App pools and websites…

Moving WSUS Content Staging Folder

Symptom: Bloated Wsus Staging Folder: Resolution: $wsusNewContentFolder='D:\Wsus\WsusContent'stop-service 'wsus service'&'C:\Program Files\Update Services\Tools\wsusutil.exe' movecontent $wsusNewContentFolder "$wsusNewContentFolder.log"start-service 'wsus…

Start All Automatic Services on Windows

Current version: # startAllAutoServices.ps1 # version 0.0.2 # Description: # - This script to scan…

Windows Update Error Code 0x80244022

Symptom: There were some problems installing updates, but we'll try again later. If you keep…

Windows Update Error

Error Message: There were some problems installing updates, but we'll try again later. If you…

T-SQL Msg 3101 Exclusive access could not be obtained because the database is in use

Symptom: Msg 3101, Level 16, State 1, Line 2Exclusive access could not be obtained because…

SQL Error Msg 3201, Level 16, State 2

Sample Error Message: Msg 3201, Level 16, State 2, Line 2Cannot open backup device '\\1.1.1.1\d$\backup\TEST_MSCRM.bak'.…

Remote Desktop: Broken Domain Trust Relationship Between Workstation an Primary Domain Controller

Symptom Remote desktop initiation toward a certain server would result in an error message with…

PowerShell: Convert Array to Hash and back to Array

# convert 2D Array to Hash Table while removing any duplicate keys function arrayToHash($arr){ $hash…