Usernames and passwords for MS SQL

You may use below t-sql statement -

CREATE LOGIN login_name WITH PASSWORD='password'
GO
USE DATABASE_NAME
GO
--Creating User - user_name .. Login and user_name is mostly the same --
CREATE USER user_name FROM login_name
GO
--Also you might need to grant some roles - such as dbo (db_owner), datareader (db_datareader) or datawriter (db_datawriter)--

USE DATABASE_NAME
GO
exec sp_addrolemember 'db_owner' , 'user_name'
GO

You can also just create that user in Management Studio (SSMS) under "Security", if you prefere the GUI approach.

Please check the following:
http://msdn.microsoft.com/en-us/library/aa337545.aspx

Thanks for the info
I created a login via the GUI but the login fails as image.
Being new to MS SQL I regret I dont know about t-sql statements.
 

What is the password for sa?

The sa password is defined when installing MSSQL Express. It might be empty, but I don't think so.

hi,

if you doing for your own use then below link currently wont require.

if you trying to create multiple users with different role then check out following link.

https://www.experts-exchange.com/questions/26532011/Is-there-a-way-to-create-new-user-into-sql-server.html?sfQueryTermInfo=1+10+30+brichsoft+creat+login

Thanks,
I revised the sa password as suggested by Brichsoft but get the fail error message.
 

You will need to enable the sa account under Security.
This completed the puzzle so thanks for all of the help.
Many thanks
John