MPControl 500 error after removing WSUS and the SUP from SCCM

One thing I have found interesting, intriguing, and somewhat ironic is a glorious lack of need for Configuration Manager in my environment due to things like Azure AD and Intune. For the sake of patching, though, I have so many disconnected systems in my labs that it made no sense to maintain both a WSUS…

0

PS without BS: Let's play "Where's that MSI?"

That infamous folder c:\windows\installer can take up a lot of space and resources, more importantly, it’s cryptic when you see a bunch of numbered MSI and MSP files. What is this good for? Well, my favorite reason is that on occasion you can find the MSI of a software package that may require a manual…

2

Recovering a SQL database via T-SQL

So this post is courtesy of a late night database issue. One of my important SQL databases was coming up suspect, so what to do? Well, here’s some TSQL that may help, if you need to recover a database: USE master GO ALTER DATABASE YourDatabase SET EMERGENCY GO DBCC CHECKDB (YourDatabase) GO ALTER DATABASE YourDatabase…

0

Locked out of SQL...No More

I had an interesting issue come up at a customer where they needed to change SQL Memory and reattach a database, neither action they could accomplish. For some reason, they had no rights to do so (and should have). How to remedy this? Before doing this, you will need the SQL Server, Instance name (I’ll…

0

So, how do you prepare for a Microsoft exam?

A lot of thoughts go into Microsoft exams, and really it’s easy to overthink these. Whether you are doing it just to get a piece of paper, your boss is making you, or you actually are intending to learn and validate your skills, there are some techniques to keep in mind. Here are the ways…

0

SCCM Servers showing their state as "Unknown"

I recently came across a unique issue where SCCM had not been reporting site status for its remote servers properly. This was actually caused by the site servers not having the rights to be able to access the registry keys set by the servers it’s trying to query to find its status. On remote SCCM servers,…

0

PS without BS: Getting AD Users with a Filter

Recently, I was asked to get a list of admin accounts within multiple domains, however, all domains had a different or multiple naming standards. For those who use PowerShell and are familiar with get-aduser, you will know quickly that the filtering feature is limited with one wildcard option, being the *. You can’t filter on…

0

Allowing RDP access to only certain IPs

I had an issue come up recently where the ask was to only allow RDP access to certain IPs. The trick here was that a Group Policy existed that set universal access to RDP through the firewall. A very simple fix can take care of this issue. In this repro, the following applies: I have…

0

I can't connect - but the firewall is off!

Sometimes you simply cannot connect to another system, in one case a domain controller. You know the server is running. You see it, you log into it, you connect to other systems from it. What are you to do? In one case, this happened in a domain controller scenario, where 2 DCs wouldn’t replicate. Now,…

0

PS without BS: How many times have you joined the domain?

Ever since the beginning of what is today called Active Directory, the default has always been to let “Authenticated Users” join computers to the domain. Authenticated Users is essentially anyone with a domain credential to access the network. This, of course, comes with a trade off – these “authenticated” users can only join computers 10…

0