sql2008问题Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance
asp.net连接Sql Server2008 Express,出现这个问题:“由于启动用户实例的进程时出错,导致无法生成 SQL Server 的用户实例。该连接将关闭。”,其英文版本的相同问题的错误信息是:“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.”
微软的bug
解决方法:
在WindowsXP下:
删除目录C:\Users\Administrator\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
在Windows2003下:
删除目录C:\Documents and Settings\Administrator\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
在Windows7下:
删除目录 C:\Users\Classic .NET AppPool\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS