Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 02, 2013 08:49 AM by Chen Yu - MSFT
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:
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.
Jan 02, 2013 08:49 AM|LINK
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