Run this on the Server
CREATE LOGIN user WITH password='1231!#ASDF!a';
Run this on DB
CREATE USER user FROM LOGIN user;
EXEC sp_addrolemember 'db_owner', 'user';
Run this on the Server
CREATE LOGIN user WITH password='1231!#ASDF!a';
Run this on DB
CREATE USER user FROM LOGIN user;
EXEC sp_addrolemember 'db_owner', 'user';