Interesting. My confusion is, what the system logins are. Generally, I consider them some built-in logins such as sa, NT SERVICE\xxx, etc.
In the company I'm working for, Service Account means the account which is used by MSSQL Services, and Application Accounts are for applications( such as Website and other applications ).
The user was asking about system accounts (not logins) and then asked about SQL logins. Two very different things that Thom explained well.
NT SERVICE\xxx - those are generally virtual accounts, not built in logins. Virtual accounts explained in this documentation:
Configure Windows Service Accounts and Permissions
Sue
Thanks for your explanation and correction. Glad to learn something:-)
It doesn't help that they keep modifying things with the accounts and how MS implements it on just about every release. 🙂
It's all good though, gets more secure on every change. It's just hard to remember which version uses what.
Sue