Overblog Follow this blog
Edit post Administration Create my blog
Balavardhan Reddy Narani

Errror Message : Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance

March 7 2009 , Written by Balavardhan Published on #ASP.Net

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

I hosted a dotnet web application, backend as SQL Server 2005 in Client location. Firstly It working fine, after some days. we got Error Message from the application
i.e.
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
After I did some searching, I find the solution: i.e. you need to delete the
C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
directory

What everyone else failed to emphasize is that you might need to restart Windows. Simply bouncing the SQL Server Express service doesn't always fix it.
After I Delete the SQLEXPRESS directory, my application working normally

Share this post

Repost 0

Comment on this post