Persist Security Info

  • Thread starter Thread starter Alberto
  • Start date Start date
A

Alberto

Could you tell me what it's for the "Persist Security Info ..." value in a
connection string.

Thank you.
 
Persist Security Info means that the security information that was used to
create the connection to the database is retained so that further
connections can get that security information without the it having to
provided again. This is a bad thing:

http://msdn.microsoft.com/library/d...cpguide/html/cpconsecureadonetconnections.asp

HTH,

Kyril

Keep Persist Security Info as False
Setting Persist Security Info to true or yes will allow security-sensitive
information, including the userid and password, to be obtained from the
connection after the connection has been opened. If you are supplying a
userid and password when making a connection, you are most protected if that
information is used to open the connection, and then discarded. As a result,
your option that helps to provide greater security is to set Persist
Security Info to false or no.

This is especially important if you are supplying an open connection to an
untrusted source or persisting connection information to disk. Keeping
Persist Security Info as false helps ensure that the untrusted source does
not have access to the security-sensitive information for your connection
and also helps ensure that no security-sensitive information is persisted to
disk with your connection string information.

Persist Security Info is false by default.
 
When you're using a UDL or similar persistent storage it means the password
gets stored in clear text along with everything else.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top