无法生成SQL Server的用户实例因故障在检索用户的本地AP [英] Failed to generate a user instance of SQL Server due to failure in retrieving the user's local ap

问题描述

这是我第一次部署一个asp.net网站。一切正常我的本地计算机上，但是当我发表本网站的远程计算机得到错误的无法生成SQL Server的用户实例，由于未能在检索用户的本地应用程序数据路径请确保该用户在计算机上的本地用户配置文件，连接将被关闭

This is my first time to deploy an asp.net web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "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"

（仅在该尝试访问数据库页）

(only in pages that try to access the database)

帮助pleaseee

Help pleaseee

推荐答案

在IIS在Vista / Windows 7中/ Server 2008的操作系统，
选择应用程序池，然后选择高级设置。在过程模型发现加载用户配置文件，并将其设置为true。

In IIS under Vista/Windows 7/Server 2008 OS, Select the application pool and then "advanced settings." Under "process model" find "Load User Profile" and set it to true.

SQL现在应该默认的应用程序池帐户下加载。

SQL should now load under the default app pool account.

这篇关于无法生成SQL Server的用户实例因故障在检索用户的本地AP的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！