SQL Express - Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.: digWin

digWin is a collaborative platform for techies, mostly Microsoft stories and comments shared by the community.

home » Security » Windows Security » SQL Express - Failed to generate a user...

SQL Express - Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.

Huh?

That was the first thought that went through my head when seeing this error from SQL Express when trying to open a .mdf file in Visual Studio 2005. It turns out that there is supposedly a bug with the OS (http://support.microsoft.com/?id=896613) that causes this error if you have logged into the machine through Remote Desktop since the last reboot. This means that it's pretty much imposible to use SQL Express while logged in remotely. The so

posted by jhorra (30) in Windows Security 27 months ago email this leave a comment