Ad

Sql Authentication Or Windows Auth

- 1 answer

For my asp.net website with forms authentication, I will use Windows integrated security to access a sql database. I will give DB permissions to the ASPNET or NETWORK SERVICE. Under what circumstances would I use SQL authentication instead?

Ad

Answer

Use SQL Auth when you need non-Windows machines to make a DB connection.

Keep in mind that it adds another attack vector (another set of credentials to compromise the machine), so make sure you really need it before using it.

Ad
source: stackoverflow.com
Ad