How to grant a Windows user or group login access to SQL Server (Enterprise Manager)

To grant a Windows NT 4.0 or Window 2000 user or group login access to SQL Server

1. Expand a server group, and then expand a server.
   
   
2. Expand Security, right-click Logins, and then click New Login.
   
   
3. In the Name box, enter the Microsoft® Windows NT® 4.0 or Windows® 2000 account (in the form DOMAIN\User) to be granted access to Microsoft SQL Server™.
   
   
4. Under Authentication, click Windows Authentication.
   
   
5. Optionally:
   • In Database, click the default database to which the user 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 Windows NT User or Group