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.
you might need to delete the C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory.
Guys, I'm having this same problem ever since I went to VS2010 and I'm running SQL2008 Express on Vista.
Now VS can not create the aspnet_db in app_data folder and I can not either, getting the same error with user instance.
I have changed the SQL server setting to "Local System" but I can't not find the directory
"C:\Users\[userid]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS" on my Vista to delete it
Click "Mark as Answer" on the post that helped you.
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
I just wanted to give a shout out/thank you. I have SQL Server 2008 installed - pointing both to remote servers and to my local machine. I then installed SQL Server Express as I was following a TekPub series and was unable to create an mdf file (?!?).
I was getting this error and scratching my head. You advice resolved this issue.
Ben that folder is hidden if you use windows explorer, just search for SQLEXPRESS in C:\Users or type in directly:
C:\Users\[user_name]\AppData\Local\Microsoft\Microsoft SQL Server Data
Thank you guys, I had this problem for days (after uninstalling my instance of SQL2005 and leaving SQL2008) but after changing to run SQL Express to the local account and deleting the SQLEXPRESS folder it worked like a charm (no need to restart)
DiegoVieira
Member
30 Points
33 Posts
Re: Failed to generate a user instance of SQL Server
Dec 07, 2009 03:00 PM|LINK
That workd for me too..
Thanks
S.S.S
Member
10 Points
5 Posts
Re: Failed to generate a user instance of SQL Server due to a failure in starting the process for...
Jan 19, 2010 11:35 AM|LINK
Even I have faced the same situation.
I'm using Visual Studio 2005 for a website developement.
When I am trying to add a database.mdf file is showed me the 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.
Then What I did,
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
Now my problem got solved.
Subha Shanketa Sutar
Software Engineer
subhashanketa@hotmail.com
Banglore
mwee
Member
2 Points
1 Post
Re: Failed to generate a user instance of SQL Server
Jan 21, 2010 06:45 AM|LINK
Thanks it works
BenHayat
Member
59 Points
33 Posts
Re: Failed to generate a user instance of SQL Server
Mar 24, 2010 08:17 PM|LINK
Guys, I'm having this same problem ever since I went to VS2010 and I'm running SQL2008 Express on Vista.
Now VS can not create the aspnet_db in app_data folder and I can not either, getting the same error with user instance.
I have changed the SQL server setting to "Local System" but I can't not find the directory "C:\Users\[userid]\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS" on my Vista to delete it
Could someone help with this issue please?
Thanks!
Best Regards;
..Ben
BenHayat
Member
59 Points
33 Posts
Re: Failed to generate a user instance of SQL Server
Mar 24, 2010 09:38 PM|LINK
Well, I went ahead and uninstalled SQL2008 and then reinstalled it and I still get error if I try to create an SQLDB in VS10.
Any thoughts?
Thanks!
Best Regards;
..Ben
TATWORTH
All-Star
72405 Points
14018 Posts
MVP
Re: Failed to generate a user instance of SQL Server
Apr 06, 2010 02:48 PM|LINK
For further help with SQL Server Express, please ask at:
http://social.msdn.microsoft.com/Forums/en-GB/sqlexpress/threads
This earns you a point and marks your thread as Resolved so we will all know you have been helped.
FAQ on the correct forum http://forums.asp.net/p/1337412/2699239.aspx#2699239
abhinaynag
Member
12 Points
19 Posts
Re: Failed to generate a user instance of SQL Server
Apr 09, 2010 06:25 AM|LINK
It worked Finally!!!!! dont even need to restart computer just refresh database explorer and it works a charm!!!!!
ash_mangu
Member
10 Points
16 Posts
Re: Failed to generate a user instance of SQL Server
May 06, 2010 06:06 PM|LINK
Hi,
I'm wanting to create an instace bcoz bydefault their is no instance installed on my computer can you help me
http://gingercaterers.com/
Torunesol143
Member
2 Points
1 Post
Re: Failed to generate a user instance of SQL Server
Aug 09, 2010 07:06 PM|LINK
PassHours -
I just wanted to give a shout out/thank you. I have SQL Server 2008 installed - pointing both to remote servers and to my local machine. I then installed SQL Server Express as I was following a TekPub series and was unable to create an mdf file (?!?).
I was getting this error and scratching my head. You advice resolved this issue.
Thanks again!
- Rich
SQL Server Express
ralechung
Member
2 Points
1 Post
Re: Failed to generate a user instance of SQL Server
Aug 30, 2010 05:25 AM|LINK
Ben that folder is hidden if you use windows explorer, just search for SQLEXPRESS in C:\Users or type in directly:
C:\Users\[user_name]\AppData\Local\Microsoft\Microsoft SQL Server Data
Thank you guys, I had this problem for days (after uninstalling my instance of SQL2005 and leaving SQL2008) but after changing to run SQL Express to the local account and deleting the SQLEXPRESS folder it worked like a charm (no need to restart)