综合安全 [英] Integrated security
问题描述
我正在开发一个从SQL Server 2005访问数据的.Net应用程序。此应用程序将托管在IIS 7.0网络浏览器上。
我想使用集成安全性进行数据访问。这是我在我的web.config文件中尝试的,当我从Visual Studio 2008中启动我的应用程序时工作正常,但是当我从服务器(使用IIS 7 Web服务器)启动它时,它给了我错误。
< add key =" DatabaseString" value =" Driver = {SQL Server}; Server = CDYMGR; Database = HVDMG; Integrated Security = true" />
或者< add key =" ConnectionString" value =" Data Source = CDYMGR; Initial Catalog = HVDMG; Integrated Security = true" />
错误: System.Data.SqlClient.SqlException:用户登录失败' MSA \HVAULT $'。
在IIS或SQL Server或网络/活动目录设置中,我需要进行哪些设置才能让我的应用程序从服务器获取数据库?
谢谢。
I am developing a .Net app that accesses data from SQL Server 2005. this app will be hosted on IIS 7.0 websrever.
I want to use integrated security for data access. Here is what I tried in my web.config file, which works fine when I launch my app from within Visual Studio 2008, but when I launch it from the server (with IIS 7 web server), it gives me error.
<add key="DatabaseString" value="Driver={SQL Server};Server=CDYMGR;Database=HVDMG;Integrated Security=true" />
OR
<add key="ConnectionString" value="Data Source=CDYMGR;Initial Catalog=HVDMG;Integrated Security=true" />
Error: System.Data.SqlClient.SqlException: Login failed for user 'MSA\HVAULT$'.
What setup do I have to do in IIS or SQL Server or network/ active directory settings to let my app get database access from the server?
Thanks.
推荐答案
你在不同的盒子上有SQL Server吗?
Do you have the SQL Server on a different box ?
这篇关于综合安全的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!