Persist Security Info Property=true and Persist Security Info Property=false

by

Even if you set Persist Security Info=true OR Persist Security Info=false
it won’t show a difference up front. The difference is happening in the background.

When Persist Security Info=False, security-sensitive
information, such as the password, is not returned as part of the
connection if the connection is open or has ever been in an open
state.

If you set Persist Security Info=True, Windows will remember the password specified in the connection string.

That’s the difference.

MSDN Explanation

Setting Persist Security Info true or false will come into effect only if you mention username and password in the connection string. If you mention username and password in the connection string and set Persist Security Info as false then the credentials cannot be extracted, but if you set Persist Security Info as true while giving credentials in the connection string, windows will remember the credentials, and it can be extracted programmatically.

More Related Contents:

  1. SQL Express connection string: mdf file location relative to application location
  2. How to fix “The ConnectionString property has not been initialized”
  3. How to create an Access database at runtime in C#?
  4. How to create Microsoft Access database in C# programmatically?
  5. How to insert an image into an Access OLE field via .NET
  6. Retrieve List of Tables in MS Access File
  7. import csv file to sql database in c# window application without header row [duplicate]
  8. Using parameters inserting data into access database
  9. How can I set an SQL Server connection string?
  10. Writing large number of records (bulk insert) to Access in .NET/C#
  11. OLEDB Parameterized Query
  12. Bulk-deleting in LINQ to Entities
  13. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  14. What’s wrong with these parameters?
  15. Local database, I need some examples
  16. How to connect to a MS Access file (mdb) using C#?
  17. How can I update a cell value in a dB table, using SQL Server CE and C# (Visual Studio 2010)
  18. Received an invalid column length from the bcp client for colid 6
  19. What is the point of “Initial Catalog” in a SQL Server connection string?
  20. encrypt SQL connectionstring c#
  21. Using MySQLConnection in C# does not close properly
  22. Get ConnectionString from appsettings.json instead of being hardcoded in .NET Core 2.0 App
  23. How do I use Web.Config transform on my connection strings?
  24. Can I commit changes to actual database while debugging C# in Visual Studio?
  25. Will a using block close a database connection?
  26. How to use String property as primary key in Entity Framework
  27. What is the fastest way to read data from a DbDataReader?
  28. Is it possible to perform joins across different databases using LINQ?
  29. Do we have transactions in MS-Access?
  30. Is SqlConnection.Close() need inside a Using statement?

Leave a Comment