SQL Server database connection mode in ASP.

I fresh students, every time to engage in research and development connected to the database to the previous connection code to copy or search from the Internet, it is troublesome, but also the heart of the careless can't remember it, so write down

Of course, the most commonly used is SQL Server authentication, <ADD name= "conn" connectionstring= "Data source=.;i Nitial Catalog=dbname; Persist Security info=true; User Id=sa; password=; Multipleactiveresultsets=true "
Providername= "System.Data.SqlClient"/>

Windows authentication, <add name = "Conn" connectionstring= "Integrated security=sspi;data source=.;i Nitial catalog=dbname; " />

There is no explanation as to what the difference is, or what each word means.

SQL Server database connection mode in ASP.