Difference Between Persist Security Info And Integrated Security?

connection-string, sql-server-2005

Solution

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.

Problem

In a SQL Server connection string, what's the difference between `Integrated Security = True/SSPI` and `Persist Security = True`?

Original source