USE [master]
CREATE DATABASE UmbrellaEnterprises
GO
USE [UmbrellaEnterprises]
CREATE LOGIN support_team_login WITH PASSWORD = 'P@ssW0rd';
CREATE USER support_team_usr FOR LOGIN support_team_login;
EXEC sp_addrolemember N'db_owner', N'support_team_usr'
- Remember to use the login not the user to login
- You could set the same value in login and user