topic Granting permission for windows authenticated group in sql server 2008 in Data Management Questions https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449599#M25686 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Invalid parameter value passed to function</SPAN><BR /><SPAN>Failed to execute (ChangePrivileges).</SPAN><BR /><BR /><SPAN>Does anyone can help me to figure out what Iâ??m doing wrong? </SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Mon, 23 May 2011 08:20:58 GMT Sergiydodon 2011-05-23T08:20:58Z Granting permission for windows authenticated group in sql server 2008 https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449599#M25686 <HTML><HEAD></HEAD><BODY><SPAN>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.</SPAN><BR /><BR /><SPAN>ERROR 999999: Error executing function.</SPAN><BR /><SPAN>Invalid parameter value passed to function</SPAN><BR /><SPAN>Failed to execute (ChangePrivileges).</SPAN><BR /><BR /><SPAN>Does anyone can help me to figure out what Iâ??m doing wrong? </SPAN><BR /><SPAN>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.</SPAN><BR /><SPAN>Thanks in advance.</SPAN></BODY></HTML> Mon, 23 May 2011 08:20:58 GMT https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449599#M25686 Sergiydodon 2011-05-23T08:20:58Z Re: Granting permission for windows authenticated group in sql server 2008 https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449600#M25687 <HTML><HEAD></HEAD><BODY><SPAN>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...</SPAN></BODY></HTML> Tue, 24 May 2011 13:43:59 GMT https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449600#M25687 Sergiydodon 2011-05-24T13:43:59Z Re: Granting permission for windows authenticated group in sql server 2008 https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449601#M25688 <HTML><HEAD></HEAD><BODY><P>32 chars still valid. Can add "ESKILSTUNA\ILM_KLK-AllPersonal" (30 chars) but not "ILM_STADSBYGGNAD_Utvecklingsenhet-AllPersonal" (45 chars).</P><P></P><P>Tested in ArcCatalog&nbsp;10.5.1.7333</P></BODY></HTML> Mon, 18 Mar 2019 09:56:29 GMT https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449601#M25688 Anonymous User 2019-03-18T09:56:29Z Re: Granting permission for windows authenticated group in sql server 2008 https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449602#M25689 <HTML><HEAD></HEAD><BODY><P>Did you figure this out? I am getting the same error while trying to add a role to a dataset.</P></BODY></HTML> Mon, 16 Sep 2019 18:49:53 GMT https://community.esri.com/t5/data-management-questions/granting-permission-for-windows-authenticated/m-p/449602#M25689 RowenaTansley1 2019-09-16T18:49:53Z