SQLServer -- 数据库连接串设置

数据库连接串设置

• 标准连接:

  "Server=Aron1;Database=pubs;UID=sa;PWD=asdasd;"

• 信任连接:

  "Server=Aron1;Database=pubs;Trusted_Connection=yes;"

  
  Integrated Security=SSPI 等同于 Trusted_Connection=yes

• Enabling MARS (multiple active result sets):

  "Server=Aron1;Database=pubs;Trusted_Connection=yes;MARS_Connection=yes"

  
  MultipleActiveResultSets=true 等同于 MARS_Connection=yes
  

• 通过网络发送数据时加密:

  "Driver=Server=Aron1;Database=pubs;Trusted_Connection=yes;Encrypt=yes"

• 连接SQL实例时附加一个数据文件:

  "Server=.\SQLExpress;AttachDbFilename=c:\mydbfile.mdf;Database=dbname;Trusted_Connection=Yes;"