How do I add a user in SQL Server?

lshaolian · Post time: 2020-3-9 20:00:01

dream88 · Post time: 2020-6-5 16:15:01

--The example is for user Albert to create a SQL Server login with a password of B5432-3M6, and the default database is corporate.

EXEC sp_addlogin'Albert','''B5432-3M6','corporate';
GO

dream88 · Post time: 2020-6-5 22:15:01

---Do not specify the default database User name test password: aa
EXEC sp_addlogin'test','aa'
GO

		Remember me	Forgot password?
Password			Register