SQL Express user instance failing when using RDP
I thought I’d log in via Remote Desktop to do some extra work from home. I attempted to run the database unit test project only for all the test to fail with the following error:
“Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.”
Turns out this is a bug in Windows XP SP2.
I installed the hotfix using Microsoft’s new Hotfix request service, and the problem is fixed.