This message occurs when users cannot connect to an Access Supply Chain database using Microsoft Excel
When entering the server name, it must contain the full FQDN (Fully Qualified Domain Name). For example, if the server name is: SERVER01
The FQDN must be written afterwards, e.g. SERVER01.CUSTOMERDOMAIN.CO.UK
If the issue continues to occur, the root certificate needs installing:-
Option 1: Install the Certificate to Trusted Root on the Client
Obtain the certificate from the SQL Server: You can use a tool like OpenSSL or Microsoft Management Console (MMC) or ask your server admin for the .cer or .crt file.
Install the certificate on the client PC
Double-click the .cer file
Click Install Certificate
Choose Local Machine (if you have admin rights).
Select Place all certificates in the following store: Trusted Root Certification Authorities
Click Finish and restart Excel
This will trust the certificate for all apps on that machine.
Option 2: Update the SQL Server to Use a Trusted Certificate
Ask the DBA or server admin to use a certificate issued by a trusted public CA (like DigiCert, Let’s Encrypt, etc.) or
make sure the entire certificate chain is installed and served by SQL Server.