New Information - SQL Server 2000 SP3.
Login identifiers (IDs) are associated with users when they connect to an instance of Microsoft® SQL Server™ 2000. Login IDs are the accounts that control access to the instance of SQL Server. A user cannot connect to an instance without first specifying a valid login ID. Members of the sysadmin fixed server role define login IDs. There are two types of logins that can be defined for instances of SQL Server:
- sp_grantlogin authorizes a Microsoft Windows® network account (either a group or a user account) to be used as a SQL Server login for connecting to SQL Server using Windows Authentication. The user does not have to specify a login when connecting to the instance of SQL Server. SQL Server uses the Windows account to validate the connection request.
- sp_addlogin defines a login account for SQL Server connections using SQL Server Authentication. The user must supply a SQL Server login account and password when connecting to the instance of SQL Server.
Security Note When possible, use Windows Authentication.