<add name="ConnectionStringName"
providerName="System.Data.SqlClient"
connectionString="Data Source=ServerNameInstanceName;Initial Catalog=DatabaseName; Integrated Security=True;MultipleActiveResultSets=True" />
<add name="ConnectionStringName"
providerName="System.Data.SqlClient"
connectionString="Data Source=ServerName;Initial Catalog=DatabaseName;Integrated Security=False; User Id=userid;Password=password;MultipleActiveResultSets=True" />