User

Create

From S, you can create new db users easily with the following script.

Run the script against the target database after replacing @@user with the required username and @@password with the password:

CREATE LOGIN @@user WITH PASSWORD=N'@@password', CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN @@user ENABLE
GO
CREATE USER @@user FOR LOGIN @@user WITH DEFAULT_SCHEMA=[dbo]
GO
EXEC sp_addrolemember 'db_owner', '@@user'
GO
EXEC sp_addrolemember 'db_datareader', '@@user'
GO
EXEC sp_addrolemember 'db_datawriter', '@@user'
GO