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
- Open the SQL Server Enterprise Manager, expand a server group, and then expand a server.
- Expand Security, right-click Logins, and click New Login.
- Select Windows Authentication.
- In the Name field, enter the Windows account (in the form DOMAIN\User) to grant access to SQL Server.
- 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