The connection with SQL Server Native Client 11.0 loses the password as soon as it is saved

Symptoms

If SQL Native Client 11.0 Provider for DaraSet connection is used, then the error

Login failed for user 'user'

is shown when trying to save the connection to base, despite the previous successful test connection.

Cause

The SQL Native Client returns the connection string without the password included, even in the SavePassword is checked. This is the peculiarity of the Microsoft system dialog that is present even in the latest version of the SQL Native Client.

Resolution

Switch on the "Persist Security Info" on the "All" tab. 
KB_SQLNativeClient.png

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.