Today, seemingly out of the blue, I was unable to connect to my MSSQLLocalDB instance of SQL Server Local DB. The error message I received indicated something went wrong during the login, purportedly with a trigger. Here's how I did some troubleshooting, research, and finally figured out a non-destructive way to get back in my … Continue reading Unable to Log In to SQL Server Local DB Due to Missing MDF File
I was having trouble connecting with the Remote Desktop protocol to a server. The error returned by the Remote Desktop Connection Manager was 7431. Using mstsc.exe the error was more descriptive and indicated a time difference between the client and the server. I verified that the time difference was not the case. Coincidentally, a support … Continue reading Remote Desktop Error 7431 may indicate a DNS problem
I ran into this problem today that didn't take a long time to resolve, but took me a little by surprise. Most of my SSIS packages use the Lookup transformation component to look up keys used in source systems and match them to the data warehouse. When SSIS packages fail at the Lookup component, the most common cause is that the source system's key does not exist in the data warehouse and must be added first. This time was different, however.
So I am borrowing this title from Mark Russinovich because this one took a while to figure out. I am writing this down mostly for my own records, but perhaps someone may find value in this encounter. Rewind to SQL Saturday 285 Atlanta 2014. At the end of the session, I get distracted and close … Continue reading Case of the Unexplained (Aelterman Edition): fingerprint readers, Windows Biometric Service and a few false turns towards VPN and dead SSD
If you're running Windows Server Update Services (WSUS) 3.0 Service Pack 2, have enabled SSL (the default I think) and now have Windows 8.1 Update clients, you'll find that those clients are unable to connect to the WSUS server to check for updates. I am writing this blog post to collect all symptoms and all … Continue reading Windows 8.1 Update Cannot Connect to SSL-Enabled WSUS 3 SP 2
I ran into this error today in SQL Server 2012. It was caused by having promoted a package-level connection manager to project-level and then copying and pasting some data flow components from one package to another in the same project. By copying the data flow components from one package to another, the SSIS designer also copied a … Continue reading SSIS 2012: Failure Saving Package: An Item With the Same Key Has Already Been Added
I spent a few hours today trying to understand why a number of computers in our (higher education computer lab) environment did not want to download updates for drivers using Lenovo's System Update tool. I tried disabling the usual suspects (particularly McAfee Anti-Virus 8.7i Enterprise and the Windows Firewall), but nothing made a difference. So then … Continue reading Software Interplay Issues: Netop Vision 7.2 and Lenovo System Update 4.01