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

How to Install SQL Server 2000

How To

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