How to add Sysadmin login to SQL Server?
sysadmin is a server role; it can be applied to any login. When installing SQL Server a login sa is created with this privilege; you can specify the password when you’re installing SQL Server. Or you can create your own login: CREATE LOGIN adminuser WITH PASSWORD = ‘ABCDegf123′; GO EXEC master..sp_addsrvrolemember @loginame = N’adminuser’, @rolename … Read more