SOURCE support documents

SOURCE automation configuration

SOURCE Troubleshooting

Source automation development

Create new Admin Account

-- in master
create login [username] with password = 'newpassword'
create user [username] from login [username];

-- if you want the user to be able to create databases and logins
exec sp_addRoleMember 'dbmanager', 'username';
exec sp_addRoleMember 'loginmanager', 'username'

Create new database User Account

-- in master
create login [username] with password = 'newpassword'

-- in each individual database, to grant dbo
create user [username] from login [username];
exec sp_addRoleMember 'data_reader', 'username'; -- read only account
-- or
exec sp_addRoleMember 'db_owner', 'username'; -- db developer account