Adding a SQL Server Login
New Information - SQL Server 2000 SP3.
Security Note When possible, use Windows Authentication.
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:
- An instance of SQL Server is running on Microsoft Windows 98.
- SQL Server is configured to operate in Mixed Mode and you must add SQL Server logins accounts for connections from clients that do not use supported versions of Windows or from legacy applications that use SQL Server Authentication.
Adding SQL Server logins is required:
- For applications that connect to products from other vendors.
- For applications designed to for 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.
To add a SQL Server login