Login IDs are associated with users when they connect to Microsoft® SQL Server™. They are the accounts that control access to the SQL Server system. A user cannot connect to SQL Server without first specifying a valid login ID. Login IDs are defined in SQL Server by members of the sysadmin fixed server role.
sp_grantlogin authorizes a Microsoft Windows NT® network account (either a group or a user account) to be used as a SQL Server login for connecting to SQL Server using Windows NT Authentication. sp_addlogin defines a login account for SQL Server connections using SQL Server Authentication.
| Logins | sp_addlogin |
| sp_grantlogin |