Exception checking if table MigrationVersionInfo in exists

Hello there,

I migrated our nopCommerce site from 3.5 to 4.60.3. But after running and hosting it on IIS facing following error:

fail: FluentMigrator.Runner.Processors.SqlServer.SqlServer2016Processor[0]
      There was an exception checking if table MigrationVersionInfo in  exists
      Microsoft.Data.SqlClient.SqlException (0x80131904): 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.)
       ---> System.ComponentModel.Win32Exception (0x80090325): The certificate chain was issued by an authority that is not trusted.
         at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
         at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
         at Microsoft.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose)
         at Microsoft.Data.SqlClient.TdsParserStateObject.SNIWritePacket(PacketHandle packet, UInt32& sniError, Boolean canAccumulate, Boolean callerHasConnectionLock, Boolean asyncClose)
         at Microsoft.Data.SqlClient.TdsParserStateObject.WriteSni(Boolean canAccumulate)
         at Microsoft.Data.SqlClient.TdsParserStateObject.WritePacket(Byte flushMode, Boolean canAccumulate)
         at Microsoft.Data.SqlClient.TdsParser.TdsLogin(SqlLogin rec, FeatureExtension requestedFeatures, SessionData recoverySessionData, FederatedAuthenticationFeatureExtensionData fedAuthFeatureExtensionData, SqlConnectionEncryptOption encrypt)
         at Microsoft.Data.SqlClient.SqlInternalConnectionTds.Login(ServerInfo server, TimeoutTimer timeout, String newPassword, SecureString newSecurePassword, SqlConnectionEncryptOption encrypt)

AniR wrote:
That indicates a SSL related access issue to SLQ server.
See if this helps https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn

New York wrote:
This is my Connectionstring:

"ConnectionString": "Data Source=DESKTOP-D83D6N;TrustServerCertificate=True;Encrypt=true;Initial Catalog=fargetta1_357_db;MultipleActiveResultSets=true;Integrated Security=False;Persist Security Info=True;Connect Timeout=120"

Still facing the same error.

AniR wrote:
Did you just remove the:
   User ID=...;Password=...
for your post.  Because if Integrated Security=False, you need to specify user id & pwd.

Have you tried to connect with SSMS?  If it works in SSMS, then check all the tabs in the SSMS connection Options dialog to see what is selected.
Or better, use Visual Studio IDE, Click View > Server Explorer, add a connection, and then test it.  If OK, then click the Advanced Button and can get the connection string at the bottom of the Advanced Properties Window.

still facing the error