We tried adding Encrypt=yes
That works if the linked server points to an other SQL Server, which supports encrypted communication.
MS Access don't support encryption.
https://www.connectionstrings.com/access/
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
In our product, we have are using linked server with Access database, which is located in same server. (SQL Server + MDB files are in same server).
During security vulnerability scans at organization, the issue raised on linked server with Access database. Issue is 'linked server not using encryption in data transit'.
Use case: Few of the SQL stored procedures are querying data from linked server which intern use link enabled to Access database.
We tried adding Encrypt=yes as connecting string while adding linked server definition, with this option, linked server throwing error as "could not initialize OLEDB provider for the linked server 'database'.
Looking for help in this use case as we dont see any article on encryption used with linked server on access databases.
We tried adding Encrypt=yes
That works if the linked server points to an other SQL Server, which supports encrypted communication.
MS Access don't support encryption.
https://www.connectionstrings.com/access/
Hi there,
This is a general error message, could you please share us more error message about this issue from SQL server error log. For SQL Server Authentication, a login with the exact same name and password must exist on the remote server.
The below thread discusses the same issue and you can try out some troubleshooting steps from this and see if that helps you to sort the Issue.
Enable encrypted connections to the Database Engine https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/enable-encrypted-connections-to-the-database-engine?view=sql-server-ver15
------------------------------------------------------------------------------------------------------------------------------------------------------
--If the reply is helpful, please Upvote and Accept it as an answer--