> For the complete documentation index, see [llms.txt](https://kwcsec.gitbook.io/the-red-team-handbook/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kwcsec.gitbook.io/the-red-team-handbook/infrastructure/sql/ms-sql/basics.md).

# Basics

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.
* [Full list](https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-2017).