问题描述
任何人曾经得到这个错误和/或有什么想法就可以了的原因和/或解决方案?
Anybody ever get this error and/or have any idea on it's cause and/or solution?
我代表一个朋友问这个,但有在的
I'm asking this on behalf of a friend but there is info at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=125227&SiteID=1
更新
连接字符串是= \ SQLEX $ P $干燥综合征; AttachDbFilename = C:\ TEMP \ HelloWorldTest.mdf;集成安全性=真
The connection string is "=.\SQLEXPRESS;AttachDbFilename=C:\temp\HelloWorldTest.mdf;Integrated Security=True"
我提出的用户实例=假。这为他工作。
I suggested the "User Instance=false". That works for him.
推荐答案
下面是回答你的问题:
很多时候,老用户的实例创建一些prevent一个新的SQL防爆preSS用户实例被创建的临时文件。当这些文件被删除一切开始正常工作。
Very often old user instance creates some temp files that prevent a new SQL Express user instance to be created. When those files are deleted everything start working properly.
首先确认用户实例运行在SQL Server Management Studio中的下列SQL启用:
First of all confirm that user instances are enabled by running the following SQL in SQL Server Management Studio:
exec sp_configure 'user instances enabled', 1.
GO
Reconfigure
运行查询,重新启动您的SQL Server实例之后。现在,删除以下文件夹:
After running the query restart your SQL Server instance. Now delete the following folder:
C:\ Documents和Settings \ {YOUR_USERNAME} \本地设置\应用数据\微软\ Microsoft SQL Server数据\ {SQL_INSTANCE_NAME}
请确保您替换 {YOUR_USERNAME}
和 {SQL_INSTANCE_NAME}
用合适的名字。
Make sure that you replace {YOUR_USERNAME}
and {SQL_INSTANCE_NAME}
with the appropriate names.
来源:Fix错误由于启动进程的用户实例失败导致无法生成SQL Server的用户实例。
这篇关于System.Data.SqlClient.SqlException:在无法生成SQL Server的用户实例由于启动该进程为用户实例失败。该连接将被关闭的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!