由于检索用户的本地应用程序数据路径失败，无法生成 SQL Server 的用户实例 [英] Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path

问题描述

vs2010 中的 net 项目我在 app_data 文件夹中有一个 db 和表，我创建了一个部署包并将该包导入到安装在我的本地机器上的 iis 服务器中.现在我在尝试执行插入时收到此错误消息.

net project in vs2010 i have a db and table inside the app_data folder, i have created a deployment package and have imported the package into an iis server that is installed on my local mechine. now i get this error message while trying to preform an insertion.

由于检索用户的本地应用程序数据路径失败，无法生成 SQL Server 的用户实例.请确保用户在计算机上有本地用户配置文件.连接将被关闭

Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed

连接字符串是:

数据源=.SQLEXPRESS;AttachDbFilename=|DataDirectory|survey.mdf;Integrated Security=True;User Instance=True

Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|survey.mdf;Integrated Security=True;User Instance=True

在 VS2010 中运行时它工作正常.

when running it inside VS2010 it`s working fine.

我该如何解决这个问题?

how can i solve this probelm ?

推荐答案

移除 User Instance=True.您不需要 RANU 实例.接下来，确保 SQL Server Express 服务帐户 具有适当的所需权限在你的 app_data 上:

Remove the User Instance=True. You don't need RANU instances. Next, make sure the SQL Server Express service account had the proper needed rights on your app_data:

cacls <pathapp_data> /E /T /G SQLServerMSSQLUser$<ComputerName>$SQLEXPRESS:F 

这篇关于由于检索用户的本地应用程序数据路径失败，无法生成 SQL Server 的用户实例的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！