In a SQL Server connection string, what's the difference between Integrated Security = True/SSPI
and Persist Security = True
?
In a SQL Server connection string, what's the difference between Integrated Security = True/SSPI
and Persist Security = True
?
Persist Security = true means that the Password used for SQL authentication is not removed from the ConnectionString property of the connection.
When Integrated Security = true is used then the Persist Security is completely irelevant since it only applies to SQL authentication, not to windows/Integrated/SSPI.