Encryption in linked servers with Access database

2022-05-10T06:30:36.633+00:00

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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,482 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
11,928 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
810 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 40,156 Reputation points
    2022-05-10T06:54:52.327+00:00

    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/


  2. Limitless Technology 39,296 Reputation points
    2022-05-16T14:35:45.493+00:00

    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.

    https://learn.microsoft.com/en-us/answers/questions/105916/cannot-initialize-the-data-source-object-of-ole-db.html

    https://learn.microsoft.com/en-us/answers/questions/196124/sql-server-cannot-initialize-the-data-source-objec.html

    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--

    0 comments No comments