In this post, I will show you how to create domain\user account for your Sitecore instance in SQL Management Studio.
Open the SQL Management Studio, and go to Security > Logins, right-click and the New Login…
In this screenshot, I’ve already added the domain user. “TECL\SCSTGCD”
In the General tab, specify the Login name, in my case “TECL\SCSTGCD”. You can also change the Default database and the Default language on the bottom part of the window.
In the Server Roles tab, specify the permission of the domain user,
Note: Every SQL Server login belongs to the public server role. When a server principal has not been granted or denied specific permissions on a securable object, the user inherits the permissions granted to public on that object. Only assign public permissions on any object when you want the object to be available to all users. You cannot change membership in public.
The sysadmin, on the other hand, is a fixed server role that can perform any operation or activity in the server. More info about Server-Level roles here.
In the User Mapping tab, explicitly specify by checking the mapping of the user for the databases and its default schema.
In the Securables tab, make sure that the Domain user have the ‘GRANT’ permission to connect to SQL, by default the Grantor is SA
In the Status tab, double check if the domain user ‘Grant’ radio button is selected and Login Enabled.
Then click the OKAY button, and there you go.