As a rule, Database Server Admin is considered to be a user who installed SQL Server. Other users can become Database Server Admins in case the Server Admin assigns them either when installing SQL Server or later by adding them to the "sysadmin" SQL Server role using one of the following methods:
SQL Server Management Studio (SSMS)1)is not installed on the computer (by default). Video Instruction:
Text Instruction:
Run as admin Command Prompt and run the following command:
sqlcmd.exe -S СерверБазДанных\Экземпляр-E -Q "CREATE LOGIN [Domain\Login] FROM WINDOWS; ALTER SERVER ROLE sysadmin ADD MEMBER [Domain\Login];"
ReplaceDatabaseServer\Instance with the database server name and the name of its instance (it’s the computer name and "SQLEXPRESS" by default);
ReplaceDomain\Login with the user account domain and login.
SSMS2)is installed on the computer. Video Instruction: <html><iframe width="100%" height="467" src="https://www.youtube.com/embed/KZV9aDB7vIs" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe></html> Text Instruction:
Start SSMS.
Connect to the selected SQL Server instance.
Select the "New login" command in the context menu of the "Security\Logins" folder in the Objects Explorer tree.
Do the following actions in the opened window:
Specify the account name in the Domain\Login format in the "Login name" field on the "General" tab
Check the box next to "sysadmin" role on the "Server roles" tab and click "OK".
1) , 2) SQL Server Management Studio (SSMS) is a free of charge software that can be downloaded on the Microsoft website.