CREATE LOGIN (Transact-SQL)

Creates a login for SQL Server, SQL Database, Azure Synapse Analytics, or Analytics Platform System databases. Click one of the following tabs for the syntax, arguments, remarks, permissions, and examples for a particular version.

CREATE LOGIN participates in transactions. If CREATE LOGIN is executed within a transaction and the transaction is rolled back, then login creation is rolled back. If executed within a transaction, the created login cannot be used until the transaction is committed.

For more information about the syntax conventions, see Transact-SQL Syntax Conventions.

HECK_POLICY = { ON | OFF }

Applies to SQL Server logins only. Specifies that the Windows password policies of the computer on which SQL Server is running should be enforced on this login. The default value is ON.

If the Windows policy requires strong passwords, passwords must contain at least three of the following four characteristics:

• An uppercase character (A-Z).
• A lowercase character (a-z).
• A digit (0-9).
• One of the non-alphanumeric characters, such as a space, _, @, *, ^, %, !, $, #, or &.