Last post Nov 28, 2018 06:21 AM by Zhi Lv - MSFT
Nov 26, 2018 10:41 AM|DPJ123|LINK
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?
Nov 26, 2018 11:55 AM|DPJ123|LINK
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
Nov 28, 2018 06:21 AM|Zhi Lv - MSFT|LINK
Failed to generate a user instance of SQL Server
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