Error while deploying the database using ReadyRoll

GenialArun

I have been facing an issue while deploying the database using ReadyRoll.


Error:  : An error occurred while attempting to deploy project scripts: 

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SSL Provider: The certificate chain was issued by an authority that is not trusted.

.

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Client unable to establish connection.

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : SSL Provider: The certificate chain was issued by an authority that is not trusted.

.

Sqlcmd: Error: Microsoft ODBC Driver 13 for SQL Server : Client unable to establish connection.

dnlnln

Sorry to hear that you've run into a problem with deploying your project. Could I ask for a few additional details to help us with troubleshooting the problem.

Firstly would you mind retrieving the connection string you're using:

1. Open the solution in Visual Studio
2. Right-click the project and select Properties
3. Switch to the Debug tab and copy the Target Connection String value
4. Remove any sensitive details such as the Data Source, User ID/Password (if present)

Also, would you be able to confirm whether this is a local or remote SQL Server host? If remote, is the target an Azure or OnPrem instance?

Lastly, could you please advise the checked/unchecked status of the following option:

1. Open a command prompt and run cliconfg.exe
2. Is the "Force protocol encryption" option checked or unchecked?

If you are unable to post any of these details here, please send them to support@red-gate.com and mention this thread URL.