SAS 9.4 M8 connectivity with SAS Connector for Snowflake

ghassanzghaib — Fri, 04 Oct 2024 19:56:58 GMT

Hi,

I'm trying to connect my SAS 9.4 M8 platform to Snowflake.

The requirement is to use MFA and not have to manually manage Snowflake accounts (this is how our Snowflake platform is configured).

The users in SAS EG are connecting with their Windows AD account but when they try to define a library to connect to Snowflake with SAS Connector for Snowflake they get an error saying that "Multi-factor authentication is required for this account."

When we disable the MFA for one user and he tries to connect he gets an error "user/password is incorrect".

I managed to have a successful connection by:

1. Disabling MFA for the user

2. Specifying a password for the user (userid in Snwoflake is the user's email)

3. Creating an authentication domain for the user in "SAS Management Console" and enter the user id and password.

The above solution will require a manual intervention every time a user is added or a password expires.

It also goes against the security requirements for our Snowflake platform.

Has anyone successfully connected to Snowflake and how?

Thanks

topic SAS 9.4 M8 connectivity with SAS Connector for Snowflake in Administration and Deployment

SAS 9.4 M8 connectivity with SAS Connector for Snowflake