SQL Server Connection Strings

1/29/2014 8:21:04 PM

SQL Server Connection String Examples:

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" />