Adding a SQL Server Login

If Microsoft® SQL Server™ is configured to operate in Mixed Mode, or when SQL Server is running on Microsoft Windows® 95/98, adding SQL Server login accounts that allow connection with a specified login name and password, rather than through a Microsoft Windows NT® user or group account, can be a preferred method of authenticating users. This can be required:

• For compatibility with applications created for earlier SQL Server versions not designed to work with Windows NT accounts.
• For applications designed to work with general users who do not have Windows NT accounts.
• To connect to SQL Server running on Windows 95/98 because Windows NT Authentication is not available on Windows 95/98.

To add a SQL Server login