Some useful links:
Microsoft tool for creating connection strings
An online tool for creating connection strings (www.aireforge.com)
A connection string is a text string that specifies the parameters needed to access to the Microsoft SQL server database. The following examples show connection strings for the most common configurations:
Data Source=1.1.1.1;Database=example_database;Integrated Security=false;User ID=MyUsername;Password=123456;
This connection string produces the same result as the previous one. It is included here to point out that some connection string keywords have many equivalents.
Data Source=1.1.1.1;Database=example_database;Integrated Security=false;User ID=MyUsername;Password=123456;
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
This connection string produces the same result as the previous one. It is included here to point out that some connection string keywords have many equivalents.
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;
The syntax of specifying the server instance in the value of the server key is the same for all connection strings for SQL Server.
Server=myServerName\theInstanceName;Database=myDataBase;Trusted_Connection=True;