Share via


Creating SQL Server Logins with Enterprise Manager

By default, SQL Server Enterprise Manager is installed by SQL Server Setup as part of the server software on computers running Microsoft® Windows® 2000 and as part of the client software on computers running Windows 2000, Windows 98, and Windows ME.

To grant access to SQL Server to a Windows 2000 user or group account

  1. Open the SQL Server Enterprise Manager, expand a server group, and then expand a server.
  2. Expand Security, right-click Logins, and click New Login.
  3. Select Windows Authentication.
  4. In the Name field, enter the Windows account (in the form DOMAIN\User) to grant access to SQL Server.
  5. Click OK.

See Also

Creating SQL Server Logins | Creating SQL Server Logins with the SQL Server Workflow Template Instantiation Wizard | Creating User and Group Accounts