First things first, we need to know which users are able to login into our SQL server instances. Logins come in two flavours, windows authentication and SQL server logins. Windows logins are tied to windows active directory accounts while SQL server logins are housed in SQL server internally.