http://blogs.msdn.com/b/ialonso/archive/2007/12/21/sql-server-2005-service-pack-2-failing-to-install-due-to-an-error-in-do-sqlgroupmember-custom-action.aspxOne colleague reported to me that one of his customers was getting the following error message when trying to install SQL Server 2005 Service Pack 2: Func Name='RestoreSetupParams'&gt; Failed to find installation media path due to datastore exceptionen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/ialonso/archive/2007/12/21/sql-server-2005-service-pack-2-failing-to-install-due-to-an-error-in-do-sqlgroupmember-custom-action.aspx#8719598Fri, 11 Jul 2008 04:56:52 GMT91d46819-8472-40ad-a661-2c78acb4018c:8719598MikeF<p>Wow, thanks for this post. I couldn&#39;t for the life of me figure out why service pack 2 was failing to install, but sure enough, the account the sql services were running under were local machine accounts with long names.</p> <p>cheers.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=8719598" width="1" height="1">http://blogs.msdn.com/b/ialonso/archive/2007/12/21/sql-server-2005-service-pack-2-failing-to-install-due-to-an-error-in-do-sqlgroupmember-custom-action.aspx#6916650Mon, 31 Dec 2007 13:01:43 GMT91d46819-8472-40ad-a661-2c78acb4018c:6916650Ed Vassie<p>Assuming that the domain CLOGIC maps to cl.prvopen.mycorporation.com in AD, then both formats of the name (domain\account and account@FQN) are equally valid and correct.</p> <p>Therefore the NetGroupAddUser API needs to be upgraded to accept both name formats, as either name format may be presented by the calling application.</p><div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=6916650" width="1" height="1">