Hi,
With new version we got problem with DatabaseReadQueryStep:
Error ocurred in step [“DatabaseReadQueryStep”, “read from sql server”,”98072629-4828-79db-9a53-39c5d97fc9de”]. Error: Robotiq.Steps.Common.Exceptions.RobotException: 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.) at Robotiq.ScriptExecutor.Repositories.DatabaseRepository.ExecuteReadDatabaseQuery(String connectionString, String sqlQuery) at Robotiq.ScriptExecutor.StepHandlers.Implementation.DatabaseReadQueryHandler.HandleCore(Boolean startRobotLocaly) at Robotiq.Steps.Common.StepHandler.Handle(Boolean startRobotLocally).
Source: DatabaseReadQueryHandler
can you provide us solution with this?
Kind regards,
Vanja
- vanja.utkovic asked 1 week ago
- You must login to post comments
After Robotiq transitioned to .NET 9, SSL certificate validation became stricter when connecting to the SQL server. You can try adding TrustServerCertificate=True to the connection string, or alternatively, install the certificate into Trusted Root Certification Authorities on the VM.
Example connection string:
Server=myserver;Database=mydb;User Id=user;Password=pass;Encrypt=True;TrustServerCertificate=True;
- Emb answered 1 week ago
- You must login to post comments
Please login first to submit.