Recently, I encountered a major problem: After Visual Studio 2010 is installed in Win8, SQL Sever 2005 or 2008 is installed, when you use Visual Studio to link a service-based database file of SQL Sever, the system always prompts "An error occurred while starting the process of the user instance, resulting in the inability to generate a user instance of SQL Sever". Baidu spent one day and one night, for various solutions, some say that the SQL Server is re-installed as an administrator, and some say that the patch is installed. A lot of problems have finally been solved, so I don't need to say that I'm happy.
Specific Practices:
XP users:
First, display the hidden folder, find the folder in the following path, and then delete the sqlexpress folder.
C: \ document and Settings \ "username" \ Local Settings \ Application Data \ Microsoft SQL Sever data \ sqlexpress.
"Username" is the name of your computer.
Win7 & 8 users:
First, all hidden folders are displayed. The path is below and the sqlexpress folder is also deleted.
C: \ User (or user) \ "username" \ appdata \ Local \ Microsoft SQL server data \ sqlexpress.