Adding active directory group with spaces in name as login in SQL Server

• speja01

  SSC Eights!

  Points: 984

  More actions

  January 21, 2013 at 10:27 am

  #273062

  Good Morning,

  I'm trying to add a active directory group with spaces in it's name to SQL Server and keep getting the error:

  SQL being executed

  USE [master]

  GO

  CREATE LOGIN [AXE\COR-00100-OP-AXE-RW-NS_CORPCITRIX_GROUPS_AXE Invoice Discrepancy] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

  GO

  Error

  Msg 15401, Level 16, State 1, Line 1

  Windows NT user or group 'AXE\COR-00100-OP-AXE-RW-NS_CORPCITRIX_GROUPS_AXE Invoice Discrepancy' not found. Check the name again.

  I know the group does exist in active directory because I can query it and it comes back. I have a feeling the problem is due to the spaces in the name. How can I go about adding this group?

• jasona.work

  SSC Guru

  Points: 50187

  More actions

  January 21, 2013 at 10:54 am

  #1579330

  I don't think it's the spaces. I just tried adding a Domain Group with spaces on my SQL, and it worked without a problem.

  I've tried it with the SQL Service running as:

  A Domain Account

  NT Authority\NetworkService

  LocalSystem

  and all three worked OK.

  I'd maybe suggest checking the Windows event logs, and the Security logs on a Domain Controller (if possible,) maybe see if something pops up there.

  Jason