In this topic step by step I show You how create system administrator login through
SQL Server Management Studio.
Connect to the server You must give name of server and name of instance if it is not default instance and login with password. Login provide an identity at the server level.
The default administrator login for SQL Server is
sa. The password for
sa is created during installation SQL Server engine. Step by step I create similar login.
So, let go to
Security node in server, expand it and right click the
Logins node and select
General tab click the
SQL Server authentication, write name of login in
Login name text field. Write the same password in
Confirm password text filed. Check only
Enforce password policy. Of cource, You may check any option, but I check these.
Object Explorer window in
Logins node You may see new login.
As You expand
Databases node You see all databases in server.