Creation of users and assigning the rights to them

For implementing security policies, creation of users accounts and administration of their rights we recommend to use authorized administration tool the Microsoft SQL Server Management Studio.

By default, there is one login for the SQL server with the username “sa” with the password specified during the installation of the SQL server (by default, this password is “123456”). This login is used to access any database and has absolutely all rights, ranging from the ability to change data and ending with changing the structure of the database. It is recommended to assign your password to this login and use it only for administering the SQL server and applying updates to databases received from developers. Create other logins for the rest of the database users.