




You can pass primary key information from these windows to a third-party external program:
Customer Maintenance Part Maintenance
| Customer Order Entry Order Management Window Purchase Order Entry Requisition Entry Vendor Maintenance |



Causes and Solutions
1. Using a Self-Signed Certificate
If your SQL Server is using a self-signed certificate, it won't be trusted by default. You can either disable encryption or trust the self-signed certificate.
Solution: Add TrustServerCertificate=True to your connection string.
2. Using a Certificate from a Non-Trusted Authority
If the certificate is from a non-trusted authority, you need to add it to the Trusted Root Certification Authorities store on the client machine.
Solution: Export the server certificate and install it on the client machine2.
Export the server certificate using MMC.
Import it into the Trusted Root Certification Authorities store on the client machine.
3. Disabling Encryption (Not Recommended)
As a quick fix, you can disable encryption in your connection string, but this is not recommended for production environments.
Solution: Add Encrypt=False to your connection string3.
By following these steps, you can resolve the SSL provider error and establish a secure connection to your SQL Server.