----------
20190217

----------
Visual studio 2015 tempate = Web forms identity with individual user account.
  <connectionStrings>
    <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-WebAuth1-20190215111250.mdf;Initial Catalog=aspnet-WebAuth1-20190215111250;Integrated Security=True"
      providerName="System.Data.SqlClient" />
  </connectionStrings>

 
----------
standard security:
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;

----------
Standard Security alternative syntax

Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False;

----------
Trusted Connection
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;
Data Source=127.0.01;Initial Catalog=DBAspNet1;Integrated Security=True


----------
Trusted Connection alternative syntax
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True;


----------
Connect via an IP address 
  
Data Source=190.190.200.100,1433;Network Library=DBMSSOCN;Initial Catalog=myDataBase;User ID=myUsername;Password=myPassword; 

DBMSSOCN=TCP/IP. 
This is how to use TCP/IP instead of Named Pipes. 
At the end of the Data Source is the port to use. 
1433 is the default port for SQL Server. 
 

----------
Attach a database file on connect to a local SQL Server Express instance

Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;

----------
Attach a database file, located in the data directory, on connect to a local SQL Server Express instance

Provider=SQLNCLI;Server=.\SQLExpress;AttachDbFilename=|DataDirectory|mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;