Create User Logins in Sql Server

Use the following command to create a login, Andrew with a passoword:

CREATE LOGIN Andrew WITH PASSWORD = 'abc123'

To enforce Password Change for first login:

CREATE LOGIN Andrew WITH PASSWORD = 'abc123' MUST_CHANGE

To create login from a Windows domain account:

CREATE LOGIN [DomainName\UserName] FROM WINDOWS

To disable login:

ALTER LOGIN Andrew DISABLE

To enable login:

ALTER LOGIN Andrew ENABLE

To change existing password for a login:

ALTER LOGIN Andrew WITH PASSWORD = 'abc123' OLD_PASSWORD = 'abc123456'

To change existing login name:

ALTER LOGIN Andrew WITH NAME = Andrew123

To delete or drop a login:

DROP LOGIN Andrew123

Alternate Titles: Add Sql Server Login, Add windows logins in Sql Server, Create User account in Sql Server, T-Sql query for adding users,creating users