Troubleshooting error: "Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1"

PROBLEM

When executing an SSIS package with MongoDB Source, you may get a list of errors:

Possible cause - Password was empty. For more info: https://zappysys.com/links/?id=10034

System.TimeoutException: A timeout occured after 30000ms selecting a server using CompositeServerSelector

MongoDB.Driver.MongoConnectionException: An exception occurred while opening a connection to the server.

MongoDB.Driver.MongoAuthenticationException: Unable to authenticate using sasl protocol mechanism SCRAM-SHA-1

MongoDB.Driver.MongoCommandException: Command saslContinue failed: Authentication failed.

CAUSE

Such an error can occur because:

1. You are passing an empty password.
2. You are not saving sensitive data in SSIS package.

SOLUTION

1. Make sure you did set the password. If you are using variables/parameters to set a variable, make sure the value of the variable/parameter is not empty.
2. In SSIS package, change ProtectionLevel option to EncryptSensitiveWithUserKey or alike:
   ​

Contact Us

If you have more question(s) feel free to contact us via Live chat or email to [e-mail]

https://zappysys.com/support/