使用sql server进行Windows身份验证 [英] Windows authentication using sql server

问题描述

嗨


我尝试过为我的应用程序使用Windows身份验证，它工作正常，但我的要求是仅在应用程序设置中添加凭据（用户名和密码） IIS7和我不想在数据库中添加访问角色（sql server 2008）是否有可能这样做？如果有

Hi
I have tried working with windows authentication for my application and it works fine, but my requirement is to add the credentials(username and password) only in the application settings in the IIS7 and I don''t want to add the access roles in the database(sql server 2008) is it possible to do it that way? please provide suggestive link if there any

推荐答案

<system.web>
   
        <compilation debug="true" targetframework="4.0"></compilation>

        <identity impersonate="true" username="yourSystemUserName" password="YourSystemPassword" />
 </system.web>

 <appsettings>
        <add key="ConnString" value="server=YourServer;database=YourDatabase;Integrated Security=true;"></add>
    </appsettings>

尝试这些设置。

try these settings.

这篇关于使用sql server进行Windows身份验证的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！