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

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

1. Expand a server group; then expand a server.
2. Expand Security, right-click Logins, and then click New Login.
3. Select Windows NT Authentication.
4. In Name, enter the Microsoft® Windows NT® account (in the form DOMAIN\User) to grant access to Microsoft SQL Server™.
5. Optionally:
   • In Database, click the default database to which the user is connected after logging into 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