Syntax for Creating SQL Server Logins CREATE LOGIN loginName {WITH PASSWORD OPTIONS, Additional Options FROM SOURCE} When creating a SQL .