Creating a Microsoft SQL Server User and Granting Permissions

Create a Microsoft SQL Server user named “ra_user,” and grant permissions to the user.

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.
Parent topic: Primary Microsoft SQL Server Configuration and Verification