
You can create a login based on a Windows principal (such as a domain user or a Windows domain group) or you can create a login that is not based on a Windows principal (such as an SQL Server login). Users need a login to connect to SQL Server. BackgroundĪ login is a security principal, or an entity that can be authenticated by a secure system. A login is the identity of the person or process that is connecting to an instance of SQL Server.

This topic describes how to create a login in SQL Server or SQL Database by using SQL Server Management Studio or Transact-SQL.

Applies to: SQL Server (all supported versions) Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics Analytics Platform System (PDW)
