SQL Server 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

Last Reply one month ago By pandeyism

Posted one month ago

 

Hi All,

Bit of a noob question, hopefully with an easy answer.

I'm working through the book "Sams Teach Yourself ASP.NET 4". Installed 'Microsoft Visual Web Developer 2010 Express' & 'SQL Server 2008 Express' from the disk in the book.
Went through the first half of the book fine (already used to classic ASP so not a massive jump), then hit the following error when trying to add a new database to a site using "Add New Item > SQL Server Database"...

"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"

I Googled the issue and most of the time this seems to be fixed by deleting the folder C:\Users\User\AppData\Local\Microsoft\Microsoft SQL Server Data and restarting. This doesn't work for me however. I have this on a work PC and my home PC and am having exactly the same issue on both.

Does anyone have any other suggestions on how I can resolve this?

Many thanks

 

Posted one month ago

Hey Duckman,

Go to Control Panel -> Administrative Tools -> Services ->

Right click on SQL Server (SQLEXPRESS) service then Properties -> Then Goto Logon tab -> Select the Local System Account option ->Apply->OK

Or

Please refer below links.

https://social.msdn.microsoft.com/Forums/en-US/219f42cf-5c99-4a72-9acb-249210c835e2/failed-to-generate-a-user-instance-of-sql-server-due-to-a-failure-in-starting-the-process-for-the?forum=lightswitchgeneral

https://community.progress.com/community_groups/sitefinity/bugsandissues/f/297/t/46217