Windows could not start the Sitecore Xconnect Search Indexer - {xConnectInstance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.
I was doing upgrade from Sitecore 9 Initial Release to Sitecore 9 Update 1. I felt somehow confident that I have followed all the steps of upgrade guide correctly, but when I reached to the step in resuming service (page 47 in the document: “Start the Sitecore XConnect Search Indexer Windows service” ), I faced the following error: “Windows could not start the Sitecore Xconnect Search Indexer - {xConnect Instance}-IndexWorker service on Local Computer. Error 1064: An exception occurred in the service when handling the control request.” Based on MSDN , this error means: “ While handling a control request, the service attempted to access an illegal address. ” I then tried to run this application manually from the folder containing it ( C:\inetpub\wwwroot\<xConnectInstance>\App_data\jobs\continuous\IndexWorker ). It is clear that this error refers to the connection string which I obtained by copying and pasting directly (my mistake during installation