Export (0) Print
Expand All
Expand Minimize

How to add a SQL Server login (Enterprise Manager)

SQL Server 2000

How to add a SQL Server login (Enterprise Manager)

  New Information - SQL Server 2000 SP3.

Security Note  When possible, use Windows Authentication.

To add a SQL Server login

  1. Expand a server group, and then expand a server.

  2. Expand Security, right-click Logins, and then click New Login.

  3. In Name, enter a name for the Microsoft® SQL Server™ login.

  4. Under Authentication, select SQL Server Authentication.

  5. Optionally, in Password, enter a password.

  6. Optionally:
    • In Database, click the default database to which the login is connected after logging into an instance of SQL Server.

    • In Language, click the default language in which messages are displayed to the user.

See Also

Adding a SQL Server Login

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