connection string parameter

Question

What specifies the following paramaeter in connection string. Initial Catalog Persist Security Info  Integrated Security

Jaish Mathews · Answer

Initial Catalog -> Database name. Here you can use database too. Persists Security Info -> Prevents sensitive information such as passwords from being returned as a part of the connection if made false. Not sure why it may need to set true. Probably a matter of performance as resetting the connection string will reset all details and these all need to be verified again. Integrated Security->Determine which credentials need to be used. When false  User ID and Password are specified in the connection. When true  the current Windows account credentials are used for authentication.