SSIS feasibility with key pair authentication for an OLEDB connection

Question

Hi ,

  I want to know if we can connect to another MS SQL DB using key pair authentication using an OLEDB connection with the help of SSIS. If not possible, how to achieve the same in ODBC connection?

Any help would be greatly appreciated

Regards

Answer 1

Hi @Anonymous ,

As far as I known, there are two possible modes to connect to SQL Server Database.

Windows Authentication mode and mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Mixed mode enables both Windows Authentication and SQL Server Authentication. Windows Authentication is always available and cannot be disabled.

choose-an-authentication-mode

I'm not familiar with key pair authentication, I could only do some online research for you about the key pair authentication in ODBC.

You may check below link to see if it is helpful.

odbc-parameters.html

Regards，

Zoe

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October

Answer 2

Hello Zoe ,

     Appreciate your response.  Could you let me know if SSIS can't support encryption while acquiring or making data transfer unless programmed externally. Any other ETL tool by Microsoft which has inbuilt encryption which acquiring connection strings or inbuilt column encryption for data transfer ?

Regards,
Bharath