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

1 comment

  • 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

Add comment

Please sign in to leave a comment.