Export (0) Print
Expand All


SQL Server 2000


  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.

See Also




© 2014 Microsoft