SQL Server - Microsoft Search Service
Posted in I recently built some Microsoft CRM 3.0 servers and came across a problem when trying to create the CRM databases on a SQL server. The CRM installation routine was returning the following error:
Action Microsoft.Crm.Setup.Server.InstallDatabaseAction failed.
The Microsoft Search service cannot be administered under the present user account
I made sure that the account that I was using to install CRM (and effectively create the CRM databases) had local admin rights on the SQL server. As it turned out, this problem was actually caused by a documented issue where the Microsoft Search Service can become out of sync with the SQL service account if the SQL service account is changed via the services applet instead of Enterprise Manager. As the following article explains, when the service account is changed via Enterprise Manager, SQL Server adds itself as an administrator to the Microsoft Search Service.
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
Once I changed the service account to use the system account, and then back to the domain service account via Enterprise Manager I was able to successfully create the CRM databases during the CRM installation routine.
