What is an SQL server connecton string?

An SQL server connection string contains information that providers need to know in order to establish a connection to a database. There are many ways to write a connection string because each provider has multiple ways to make a connection.