Domain group and user verification for Active Directory domain group
Use this page to add a domain group as the logon account to access the database.
To do so, enter the Active Directory domain group you want to use, and then enter the domain username and password.
The following table lists the items and their meanings on this page.
Item | Description |
|---|---|
Domain name | This is read-only. Shows the current domain name. |
Domain group | Click the browse button to select an Active Directory domain group. |
User name | Enter or click the browse button to select a domain user account. The user account must be in the selected Active Directory group. |
Password | Enter the password for the domain user. |
The new SQL Server logon account is created in a format like
DomainName\ActiveDirectoryDomainGroup
.The Active Directory domain group account will be assigned db_owner permissions to the selected databases.
Provide Feedback