Adding a SQL Server Login

Add Microsoft® SQL Server™ login accounts that allow a connection by means of a specified login name and password, rather than through a Microsoft Windows NT® 4.0 or Windows® 2000 user or group account, if:

• SQL Server is configured to operate in Mixed Mode.
  
  
• An instance of SQL Server is running on Microsoft Windows 98.

Adding SQL Server logins is required:

• For compatibility with applications containing data imported from other databases vendors.
  
  
• For applications designed to work with general users who do not have Windows NT 4.0 or Windows 2000 accounts.
  
  
• To connect to an instance of SQL Server running on Windows 98 because Windows Authentication is not available on Windows 98.

To add a SQL Server login

Transact-SQL