Windows integrated security in asp.net

Integrated security uses the current Windows identity established on the operating system thread to access the SQL Server database. NET application is running. You must also be sure that the identity has been granted access to the SQL Server database. This topic includes a code example that displays the current Windows identity of the ASP. NET application. Windows networks that have been configured appropriately with Kerberos authentication are able to do this. However, depending on the settings in the identity configuration element, the Windows identity established on the operating system thread for ASP.

To impersonate the Windows identity supplied by IIS, set the impersonate attribute of the identity configuration element to true as shown in the following example:. By default, other IIS security modes used in conjunction with the identity configuration element settings will not result in a token that can authenticate to a remote SQL Server. The anonymous user account can be used to authenticate against a remote SQL Server. Hi I want to connect with a sql server in asp.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Ask Question. Asked 7 years, 8 months ago. Active 7 years, 8 months ago. Viewed 1k times. ConnectionTest connectionstring ; Response. Skip to main content. This browser is no longer supported.

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback?