Wednesday, May 16, 2012

System.Exception: Action Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. ---> System.Data.SqlClient.SqlException: Windows NT user or group '\SQLAccessGroup {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}' not found. Check the name again.

Sometimes while installing MS CRM 4.0 or 2011 we used to get the bellow error.
this happens while its doing the installation where as the environment checking is over and successful.

Error:

"System.Exception: Action Microsoft.Crm.Setup.Server.GrantConfigDBDatabaseAccessAction failed. ---> System.Data.SqlClient.SqlException: Windows NT user or group '\SQLAccessGroup {xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx}' not found. Check the name again. "

there are many many resolutions for different people..

1. someone who clicked the retry , it works.. but latter they may face while adding users to CRM
2. some hot fixes will resolve the issue
3. some where uninstalled and installed again works
4. some where installing with minimun credentials with the config file by precreated groups in ad works
5. some where by creating the group in manually in db and click retry also works
6. ask the AD admin , how much it takes to reflect the ad groups once its created , then wait more than that much time and click retry, it should pick it up, so its not getting the groups or user with the name specified...
7. This can be caused due to the CRM privilege groups being left in the SQL Server Security folder when CRM is uninstalled.

below are some links to the above possible solutions
http://blog.expertsoftware.co.uk/post/2010/05/04/CRM-4-Install-and-SQL-Error-15401.aspx
http://support.microsoft.com/kb/976494
http://social.microsoft.com/Forums/eu/crm/thread/65543208-6263-45d0-9801-237c0767a4da
http://kaustubhghanekar.blogspot.com/2011/02/crm-deployment-problems-with-windows.html

point 6 is bit weired but works...

hope this will help...

thanks,
yes.sudhanshu

1 comment:

  1. Hello! I had the same error in microsoft erp recently, so thank you so much for the solution of my problem. It helped a lot!

    ReplyDelete