TCP Error 10061 when Login into ChangeAuditor

When installing ChangeAuditor form Quest (a next, next finish installation) I received an error when I tried to logon with the client but I did not get any error during or after the installation.  I got the following error:

Info”,”Could not connect to net.tcp://<FQDN>.local:49309/Service. The connection attempt lasted for a time span of 00:00:02.0779654. TCP error code 10061: No connection could be made because the target machine actively refused it <IPadress>:49309. “

 

I noticed that the ChangeAuditor service was stopped almost directly when I trying to connect with the client. First I thought it was a database credential issue because the ChangeAuditor clients where not installed yet and when they where the would connect directly to the database (when you uses the default configuration) but I  did not found any helpful messages in the log files. But TCP error code 10061 is found many times on the internet in combination with a database.

I tried several things and found out that this error happens when trying to connect to the server with the client was dude to a bad SQL database configuration. The Database that was made and configure during installation was not properly configured. I just rerun the installation process an made a new database (after I remove the original database) and everything work fine. Some times it is so easy but hard to find!