Export (0) Print
Expand All

Adding a SQL Server Login

SQL Server 2000

  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

Transact-SQL

Enterprise Manager

SQL-DMO

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft