SQL Server 2008
1.标准安全连接
Data Source = myServerAddress; Initial Catalog = myDataBase; User Id = myUsername; Password = myPassword;
2.可替代的标准安全连接
Server = myServerAddress; Database = myDataBase; User ID = myUsername; Password = myPassword;
3.信任连接
Data Source = myServerAddress; Initial Catalog = myDataBase; Integrated Security = SSPI;
4.IP连接
Data Source=128.0.0.1; Initial Catalog=myServerAddress; Persist Security Info=True;
User ID=myUsername; Password=myPassword;
MAX Pool Size=1024; Min Pool Size=50;
Connection Lifetime=30; MultipleActiveResultSets=True;