by Damiaan Peeters
11. June 2012 14:22
Just a small note for myself on creating sql user using the SQL statements.
Connect to the MASTER and create a login.
create login myNewLogin with password = 'myPassword'
The connect to the database itself and give the new login access
create user myNewUser FOR LOGIN myNewLogin
EXEC sp_addrolemember N'db_datareader', N'myNewUser'
EXEC sp_addrolemember N'db_datawriter', N'myNewUser'
There is a lot to read on MSDN