How can we help you today? How can we help you today?

Powershell scripts crashed after uninstallation of SQL Compare and Data Compare

I enabled a new user with admin privileages to run a PS sync script that calls SQL Compare and Data Compare. However this particular admin user never was able to run PS Script because an expired standard license message was thrown.

After reviewing noticed that there was 2 versions of the apps: 14 and 15 for both. So decided to uninstall version 14. Got an error of no program located but it was because PS Script was pointing to version 14 folder. The real problem was that after uninstallation was complete… the following error was shown: "Error: A connection was successfully established with the server, but then an error occurred during the login process.
(provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)" I'm still pending to reboot the server, but is quite imperative to have any other usefull, point of view. So please help us.

Thanks in advance.

Elias Gonzalez
0

Comments

2 comments

Sort by
  • Vic
    Official comment

    Hi Elias Gonzalez 

    This is due to the recent update on the Microsoft Data Connection client update.

    You can work around this by adding ";Trust Server Certificate=true" to the end of the server name in the connection dialog. For example,

    SERVERNAME;Trust Server Certificate=true
    Vic
  • farman

    Thanks for sharing this SSL errors like that can definitely be tricky, especially when tool dependencies and environment paths get mixed up after uninstallations. It’s a good call to check the cert trust chain and possibly reimport trusted root CAs if needed. Also, after uninstalling older versions, it might help to clean up environment variables or hardcoded paths in your scripts that still reference the outdated app folders. I’ve run into similar issues while managing automation tasks, including ones that sync data or fetch reports some of which I manage through scheduled PowerShell scripts. By the way, I run a utility site ytcroxyproxy that helps streamline downloading and managing video content. Tools like this come in handy when creating test datasets for sync scenarios or validating workflows during dev. Hope the reboot resolves the issue but if not, happy to brainstorm more.

    farman
    0

Add comment

Please sign in to leave a comment.