Clever Geek Handbook

Which user account is using trusted_connection in sql2008?

When I set up a trusted connection = yes in my web.config, which user account is using it?

Is this "NT AUTHORITY \ NETWORK SERVICE"?

Since I am protected in Sql management, I see: NtAuthority / System only

0


source to share


2 answers


It uses the user who is running in your application pool, the default is "NT AUTHORITY \ NETWORK SERVICE"

The title of the question should be "What user account will ASP.NET use when connecting to SQL Server using trusted___connection". Trusted_connection uses the current (or issued) credentials of the current process.

Your .NET code runs inside an application pool. You can set up a user account in the application pool as part of the IIS configuration. The best practice is to run the application pool under a restricted account and grant access to this database to the user.



Do not confuse this with the default IIS Anonymous user account, the IIS service account, or the IIS Security tab in the website settings. You can configure your web application to impersonate (run as) a user that IIS authenticates as (see Impersonation in the ASP.NET doco).

Rob

+2


source


It will use the credentials of the current user. The reason you see the NETWORK service is because the IIS application pools (by default) are running as this account.



0


source






More articles:


All Articles