SharePoint: Can't Connect to a Configuration Database When Using Configuration Wizard
- by Denis
Hello everyone.
I wonder if you could help me with the following problem:
We have a SharePoint farm consisted of two servers with an NLB (a load balancer), a database server and an index server (4 servers in total).
The issues initially appeared when we were trying to change Search settings via Shared services provider and an error was appearing with the message I can’t even remember now.
To fix that problem, we decided to restart Search services on the Index server via Central Administration… and the process had stuck with a status “stopping” for several days. We’ve found a few solutions on the forums, but nothing had helped. Then we’ve tried to exclude the Index server from the farm, but yet again, Search services would not stop. However, after a week we’ve noticed that the services finally stopped.
That was a prologue.
So, after the Search services have finally stopped, we decided to return the Index server back to the farm via the SharePoint Configuration wizard. When we click on a button “Search database instances” (don’t know the exact name in English, we have a Russian version), a correct database name and user are automatically appear in the relevant fields. Then we supply a password for the user and click “next” two times and the configuration begins. Unfortunately, at the second stage we receive the error “Could not connect to a configuration database” with the exception in the log file:
“Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.”
Now we can’t figure out why the configuration wizard can’t connect to the configuration database.
Any suggestions will be really appreciated.
