Export (0) Print
Expand All

Using the Create Login Wizard

SQL Server 2000

  New Information - SQL Server 2000 SP3.

Although the steps required to grant login access to Microsoft® SQL Server™ and a database can be performed separately, the Create Login Wizard can simplify the process. The Create Login Wizard allows you to:

  • Choose which authentication mode to use to connect to an instance of SQL Server (Windows Authentication Mode or Mixed Mode).

  • Add a Microsoft Windows NT® 4.0, Windows® 2000 or SQL Server login.

    Security Note  When possible, use Windows Authentication.

  • Add a Windows NT 4.0, Windows 2000 or SQL Server login to a fixed server role.

  • Add a Windows NT 4.0, Windows 2000 or SQL Server user to one or more databases, thereby granting the user access to those databases.

To grant SQL Server login access to a user by using the Create Login Wizard

Enterprise Manager

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