在app_data文件夹中创建.mdf文件时在visual studio 2008 sp1中出错并且错误是“由于启动...的过程失败而无法生成SQL Server的用户实例” [英] Getting error in visual studio 2008 sp1 while creating .mdf file in app_data folder and error is "Failed to generate a user instance of SQL Server due to a failure in starting the process for the...

问题描述

在sqlexpress的app_data文件夹中创建.mdf文件时在visual studio 2008 sp1中出错，错误是

由于启动进程失败而无法生成SQL Server的用户实例用户实例。连接将被关闭。

我试过从以下路径删除sqlexpress文件夹

Windows XP：C：\Documents and Settings \\ \ _YOUR_USERNAME \本地设置\Application Data \ Microsoft \ Microsoft Microsoft SQL Server数据\ SVEXPRESS



但它对我不起作用，请你需要help

Getting error in visual studio 2008 sp1 while creating .mdf file in app_data folder in sqlexpress and error is
"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 have tried by deleting sqlexpress folder from the following path
"Windows XP: C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS"

But it doesn''t work for me please need help

推荐答案

转到SQL Server Management Studio中的查询窗口并输入以下内容：

Go to Query Window in SQL Server Management Studio and type this:

exec sp_configure ''user instances enabled'', 1. <br />
Go<br />
Reconfigure

运行此查询，然后重新启动SQL Server。

Run this query and then restart the SQL Server.

这篇关于在app_data文件夹中创建.mdf文件时在visual studio 2008 sp1中出错并且错误是“由于启动...的过程失败而无法生成SQL Server的用户实例”的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！