SQL Server2008 连接字符串写法大全

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;