2
In connection strings with SQL Server I usually see the options Integrated Security and Persist Security, What each of them means and what values they can receive?
This doubt arose me seeing the comments of the following question: "Login For User Failed" error in windows service
2
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 the login information will be saved or not when there is a connection.
- if "false", at code level, once made the connection, you can get the connection string information least login/password;
- if "true", the connection string information is returned including login/password;
Of course if you use 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
Browser other questions tagged sql-server connectionstring
You are not signed in. Login or sign up in order to post.