Wednesday, August 10, 2011

Failed to generate a user instance of SQL Server

OK.

I know the updates have been real slow... Its more like I am a touch too busy to go on and update the blog. But.... lets pick it up once again and try to revive it...

Here is the one for today !! I was working on a small VS2010 WPF Application when I came across this weird 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.

Searched a bit around the net and found a lot of solutions to it.

The most un-convincing one did the trick.

Goto the below location in WIndows Explorer

C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server Data

Delete the folder SQLExpress.

NJoy !!