Problem with sp_grantlogin

• schleep

  SSChampion

  Points: 12585

  More actions

  April 20, 2010 at 12:20 pm

  #94661

  Hi all,

  Using SQL 2K sp4 on Win2K3 Server

  When I

  exec master.dbo.xp_enumgroups 'CIPS', I see the group

  IMP_Rpt_AIG_Administrator_6

  When I

  exec sp_grantlogin 'CIPS\IMP_Rpt_AIG_Administrator_6'

  on the same server, I get

  Server: Msg 15401, Level 11, State 1, Procedure sp_grantlogin, Line 41

  Windows NT user or group 'CIPS\IMP_Rpt_AIG_Administrator_6' not found. Check the name again.

  Any ideas? This worked on another SQL server in the same domain.

  xp_enumgroups 'CIPS' returns the same list on both servers.

  Thanks,

  Paul

• schleep

  SSChampion

  Points: 12585

  More actions

  May 3, 2010 at 1:29 pm

  #1161478

  In fact, it was an AD replication thing. Took waaaay longer than expected.