question

KunjibettuBharathKumar-4516 avatar image
0 Votes"
KunjibettuBharathKumar-4516 asked ZoeHui-MSFT commented

SSIS feasibility with key pair authentication for an OLEDB connection

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

sql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @KunjibettuBharathKumar-4516,

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



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

KunjibettuBharathKumar-4516 avatar image
0 Votes"
KunjibettuBharathKumar-4516 answered ZoeHui-MSFT commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @KunjibettuBharathKumar-4516,

To protect the data in an Integration Services package, you can set a protection level that helps protect just sensitive data or all the data in the package. Furthermore, you can encrypt this data with a password or a user key, or rely on the database to encrypt the data. Also, the protection level that you use for a package is not necessarily static, but changes throughout the life cycle of the package. You often set one protection level during development and another as soon as you deploy the package.
access-control-for-sensitive-data-in-packages


1 Vote 1 ·