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?
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.
None
0 Points
2 Posts
Failed to generate a user instance of SQL Server
Nov 26, 2018 10:41 AM|DPJ123|LINK
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
None
0 Points
2 Posts
Re: Failed to generate a user instance of SQL Server
Nov 26, 2018 11:55 AM|DPJ123|LINK
Sorted it.
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
All-Star
45479 Points
7008 Posts
Microsoft
Re: Failed to generate a user instance of SQL Server
Nov 28, 2018 06:21 AM|Zhi Lv - MSFT|LINK
Hi DPJ123,
You could refer to the following articles:
Fix SQL Server Express User Instance Connection Error in Visual Studio Projects
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
Best regards,
Dillion
Please remember to click "Mark as Answer" the responses that resolved your issue.
If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.