###Managing Database Logins -- first, connect to the master database ####Create Login
CREATE LOGIN login1 WITH password='<ProvidePassword>';
####Create User Remember to run the queries below on the actual database (Right click the database and select "New Query")