SQL Server Connection Strings

SQL Server Connection String Examples:

copy
Integrated Security Without Username and Password
<add name="ConnectionName" connectionString="Data Source=SQLServerServerName\SQLServerInstanceName;Initial Catalog=DatabaseName; Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>	

Username and Password With Port Number
<add name="ConnectionName" connectionString="Data Source=127.0.0.1,1496;Initial Catalog=DatabaseName;User Id=sa;Password=MyPassword" providerName="System.Data.SqlClient" />