¡¼SqlConnection (.NET) 
 
¡¼Standard Security 
  
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword; 
 
¡¼Standard Security alternative syntax 
This connection string produce the same result as the previous one. The reason to include it is to point out that some connection string keywords have many equivalents.  
Server=myServerAddress;Database=myDataBase;User ID=myUsername;Password=myPassword;Trusted_Connection=False; 
 
¡¼Trusted Connection 
  
Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI; 
 
¡¼Trusted Connection alternative syntax 
This connection string produce the same result as the previous one. 
The reason to include it is to point out that some connection string keywords have many equivalents.  
Server=myServerAddress;Database=myDataBase;Trusted_Connection=True; 
 
Use serverName\instanceName as Data Source to use a specific SQL Server instance. Please note that the multiple SQL Server instances feature is available only from SQL Server version 2000 and not in any previous versions.  

¡¼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.  
How to define which network protocol to use >> 


¡¼¡³¡µ¡º¡·¡ó¤jºõ²Å¸¹