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