I have a membership authentication database that was working fine with SQL Express 2005 and I need to make it work with SQL Express 2008. I uninstalled SQL Express 2005 and installed SQL Express 2008 and now I get this error:
Server Error in '/Admin' Application.
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 tried deleting the C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory, but it didn't help.
If your error message, you seems that you need to srart the process for the user instance, To use the User Instance functionality you need to enable it on the SQL Server. This is done by executing the following command: sp_configure 'user instances enabled',
'1'. To disable the functionality execute sp_configure 'user instances enabled', '0'.
If above method doesn't help, please check your connection string(eg, Data Source) that you connect the SQL SERVER.
codeaholic
Participant
1367 Points
707 Posts
Migrating membership from 2005 to 2008
Dec 31, 2012 06:05 PM|LINK
I have a membership authentication database that was working fine with SQL Express 2005 and I need to make it work with SQL Express 2008. I uninstalled SQL Express 2005 and installed SQL Express 2008 and now I get this error:
Server Error in '/Admin' Application.
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 tried deleting the C:\Documents and Settings\username\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory, but it didn't help.
Chen Yu - MS...
All-Star
21584 Points
2493 Posts
Microsoft
Re: Migrating membership from 2005 to 2008
Jan 02, 2013 08:49 AM|LINK
Hi,
If your error message, you seems that you need to srart the process for the user instance, To use the User Instance functionality you need to enable it on the SQL Server. This is done by executing the following command: sp_configure 'user instances enabled', '1'. To disable the functionality execute sp_configure 'user instances enabled', '0'.
If above method doesn't help, please check your connection string(eg, Data Source) that you connect the SQL SERVER.
Hope it helps.
More information: http://www.connectionstrings.com/sql-server-2008
Thanks.
Feedback to us
Develop and promote your apps in Windows Store