GrantDatabaseAccessAction failure

Hi, I'm trying to get CRM 3.0 installed on two test servers, one for the app
and one for the SQL databases. I have SQL 2005 installed and working, no
problems. But I keep getting an error when I install the CRM 3.0 app:

16:34:45| Info| Executing Install action:
Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction
16:34:52| Error| System.Exception: Action
Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction failed. --->
Microsoft.Crm.Setup.Common.SetupException: Setup could not complete this
action. This might be due to the fact that there are multiple Domain
Controllers and they have not replicated new Microsoft CRM information yet.
If this is the case you have several options: 1. Go to the domain controller
and manually force synchronization. 2. Wait 15 minutes (typically) until the
domain controller synchronizes automatically. 3. Click Retry a few times
until Setup finds a different domain controller that has the Microsoft CRM
information. ---> System.Data.SqlClient.SqlException: Windows NT user or
group 'MYDOMAIN\MYWEBSERVER$' not found. Check the name again.
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at
Microsoft.Crm.Setup.DatabaseInstaller.DatabaseUtility.ExecuteSql(InstallDatabase database, String sql, Int32 timeout)
at Microsoft.Crm.Setup.DatabaseInstaller.Helpers.GrantDboAccess(String
user)
at
Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction.GrantAccess(IDictionary
parameters)
at Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction.Do(IDictionary
parameters)
--- End of inner exception stack trace ---
at Microsoft.Crm.Setup.Server.GrantDatabaseAccessAction.Do(IDictionary
parameters)
at Microsoft.Crm.Setup.Common.Action.ExecuteAction(Action action,
IDictionary parameters, Boolean undo)
--- End of inner exception stack trace ---, Error, RetryCancel, Option1
16:36:06| Info| InputResult: Retry

And I retry many, many, many times with the same result. Has anyone
overcome this error? Thanks in advance!

-Erik

ealmquist
Mon Jan 30 12:48:21 CST 2006

I was able to resolve this with tech support over the phone. I'll post
the fix here in case it happens to someone else. The problem was the
SQL Server 2005 was looking for a user (in the Logins section of the
Database Engine) with the same name as the app/web server. For
example, my SQL Server instance was looking for 'MYDOMAIN\MYWEBSERVER$'
as a login. It was not there. MS tech support created the login
manually and retried installing MS CRM 3.0 and everything flowed
smoothly after that. My support rep mentioned that she has even heard
of problems where the login is already there, but that this error
persists. She has manually removed, then added the login with success.