In SQL Server connection strings I usually see the options Integrated Security and Persist Security , what does each mean and what values can they receive?
This question came to me by seeing the comments of the following question: Login For User Failed Error in windows service
Integrated Security means the form of authentication of the bank:
- if "false", you must enter login and password in the connection string;
- If "true", no login / password is required, as the authenticated user will be used in Windows.
Persist Security means whether or not the login information will be saved when the connection is connected.
- if "false", at the code level, once the connection is made, you can get the connection string information less login / password;
- "true", the connection string information is returned including login / password;
Of course, using Integrated Security=true , Persist Security=true becomes irrelevant, since the login / password information will not be present in the connection string.
More details here: connection string
