MS SQL is a set of windows services that runs on the Windows OS as a service account.

High level of existing SQL Server account types:

  • Windows Accounts.

  • SQL Server Logins (Inside SQL Server).

  • Database Users(Inside SQL Server).

MS SQL Server common roles are:

  • Sysadmin role –> Windows Admin for SQL Server.

  • public role –> Least privilege, something like Everyone group in Windows.

Last updated