Friday, 1 August 2008

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.

2 comments:

David Gardiner said...

If you're still having problems, try deleting any files in C:\Documents and Settings\[User Account]\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

That fixed the problem after I installed SQL Express 2008.

Ben Laan said...

Thanks David, that worked a treat - as long as I deleted those files..