We are trying to uninstall and re-install a 2008R2 instance.We have uninstalled the database engine but when we tried to re-install it we got the error "Original instance id\name in use". Unfortunately there is another (production) instance on the same machine.Using the pertinent section in the above article I configured, via GPO, the account to have "Log On As A Service" right. What makes you think the SQL Server Engine is part of the issue? As part of the troubleshooting I was doing to try and address the issue I ran Process Monitor while I was trying to start the service.
SQL Server failed to communicate with filter daemon launch service (Windows error: Windows Error: hr = 0x80070422(failed to retrieve text for this error)). full-text search functionality will not be available.At first I had made local accounts for all services because of a video I watched that used that as an . It appears you are having access denied to SQL Server Engine where your reportserver and reprotservertempdb databases [email protected] World Wide Yes. Confirm the reporting service account is a member of RSExec Role in reportserver database.So now that I actually wanted to start using reporting services I switch the account to a newly created Domain account. I then went into the Reporting Services Configuration Manager to change the account which was successful except that the step for starting the service ended in error. Do you see any access related error in your SQL Server error log?Msg 30046, Level 16, State 1, Line 16 SQL Server encountered error 0x80070422 while communicating with full-text filter daemon host (FDHost) process. To re-start the FDHost process, run the sp_fulltext_service 'restart_all_fdhosts' command or restart the SQL Server instance.Msg 30053, Level 16, State 102, Line 16 An error has occurred during the full-text query. It's not enough to just enable the service, you need to run that command also (which will also start the service for you as well as doing something internally) or restart SQL Server after the service is enabled. You now know that full-text indexing can have a problem on startup that isn't visible externally but surely this could happen to you, right?My favourite way to compare technical experience with others is to ask them about the ways in which something can fail.