Sample .NET ConnectionStrings

2/19/2013 5:42:53 PM

.NET

ADO.NET

XML

<connectionStrings>    
	<add name="Name_IntegratedSecurity_DefaultInstanceName" connectionString="Data Source=ComputerName;Initial Catalog=MyDb; Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
    <add name="Name_IntegratedSecurity_WithInstanceName" connectionString="Data Source=ComputerName\SQLServerInstanceName;Initial Catalog=MyDb; Integrated Security=SSPI;" providerName="System.Data.SqlClient"/>
    <add name="Name_UsernamePassword_WithoutPort" connectionString="Data Source=127.0.0.1;Initial Catalog=MyDb; User Id=dbUsername;Password=dbPassword" providerName="System.Data.SqlClient"/>  
	<add name="Name_UsernamePassword_WithPort" connectionString="Data Source=127.0.0.1,1433;Initial Catalog=MyDb; User Id=dbUsername;Password=dbPassword" providerName="System.Data.SqlClient"/>  
</connectionStrings>