TLS/SSH Error Upon Installing SQL Clone Agent
One of our developers recently tried to install the SQL Clone Agent on his development machine, and he received the following error: "The request was aborted: Could not create SSL/TLS secure channel."
I believe the situation is as follows. He had a previous installation of the clone agent on his machine, which he uninstalled. We then rebuilt the clone server, and he tried to download and install a new agent. This is when the error occurred.
After much troubleshooting, I think we found the problem. Even though he uninstalled the older version of the clone agent, the uninstall appears to have left its connection certificate behind. We removed the old connection certificate manually, and then the new installation proceeded without error.
The whole process looked like the following:
I believe the situation is as follows. He had a previous installation of the clone agent on his machine, which he uninstalled. We then rebuilt the clone server, and he tried to download and install a new agent. This is when the error occurred.
After much troubleshooting, I think we found the problem. Even though he uninstalled the older version of the clone agent, the uninstall appears to have left its connection certificate behind. We removed the old connection certificate manually, and then the new installation proceeded without error.
The whole process looked like the following:
- Ensure that the clone agent is uninstalled from the development machine.
- Open PowerShell as an administrator.
- Type certlm.msc and press <Enter>.
- Browse to "Certificates - Local Computer" -> "Personal" -> "Certificates".
- Right-click the "SQL Clone Agent" certificate and delete it.
- Browse to the clone server and download a new agent installer.
- Launch the agent installer and follow its prompts.
