使用sql server进行Windows身份验证

问题描述：

嗨

我尝试过为我的应用程序使用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身份验证

相关推荐