Creating a Microsoft SQL Server User and Granting Permissions
Create a Microsoft SQL Server user named ra_user, and grant
permissions to it.
Log
in to the primary Microsoft SQL Server as a system administrator, and run:
use master;
create login ra_user
with password = 'my_pass';
use <primary_database>;
create user ra_user for login ra_user;
EXEC sp_addsrvrolemember 'ra_user','sysadmin';
where my_pass is a password that complies with the
Microsoft SQL Server complexity policy.