PRB: Use BUILTIN\Group to Grant Access to Predefined Windows NT Groups (216808)



The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 (all editions)

This article was previously published under Q216808

SYMPTOMS

An attempt to grant security to a Windows NT predefined group or "Built-in" Windows NT group may return the following error message:

Error 15401: Windows NT user or group 'NT Machine\NT Group' not found.
Check the name again.

WORKAROUND

To grant access to a built-in local Windows NT group with SQL Server 7.0, use the BUILTIN\GroupName as the group name.

For example, to add the Windows NT predefined group Backup Operators to SQL Server 7.0, add the following as the Windows NT Group:

   BUILTIN\Backup Operators
				

MORE INFORMATION

Please see Adding a Windows NT User or Group in the SQL Server Books OnLine for more examples.

Modification Type:MajorLast Reviewed:10/29/2003
Keywords:kbprb KB216808