Granting permission for windows authenticated group in sql server 2008

2581
3
05-23-2011 01:20 AM
Sergiydodon
New Contributor II
Iâ??m using ArcSDE 10 with Sql server 2008 R2. I can grant privileges on dataset for sql account¸ for windows user account, but I canâ??t grant for windows authenticated group.

ERROR 999999: Error executing function.
Invalid parameter value passed to function
Failed to execute (ChangePrivileges).

Does anyone can help me to figure out what Iâ??m doing wrong?
As documentation said: â??There is no difference between creating an individual Windows login and adding a Windows group, so the how-to steps below apply to both.â?� So it must be everything fine, but not for me.
Thanks in advance.
0 Kudos
3 Replies
Sergiydodon
New Contributor II
I think I know what the problem is. The problem is not in that domain group but the length of the name of group. If I try to grant privileges to user or group with length more than 32 symbols I get that error. I think it's a bug...
by Anonymous User
Not applicable

32 chars still valid. Can add "ESKILSTUNA\ILM_KLK-AllPersonal" (30 chars) but not "ILM_STADSBYGGNAD_Utvecklingsenhet-AllPersonal" (45 chars).

Tested in ArcCatalog 10.5.1.7333

0 Kudos
RowenaTansley1
New Contributor III

Did you figure this out? I am getting the same error while trying to add a role to a dataset.

0 Kudos