Asp.Net Connecting To SQLServer Using Windows Authentication
SQL Server 驗證登入
ConnectionString="Data Source=主機位址;Initial Catalog=資料庫名稱;User ID=使用者名稱;Password=使用者密碼; "
Windows 驗證登入
ConnectionString = "Server=MyServer;Database=MyDb;Trusted_Connection=Yes;" ConnectionString = "Data Source=主機位址;Initial Catalog=資料庫名稱;Integrated Security=SSPI;"
Integrated Security=true or Integrated Security=SSPI
與
Trusted_Connection=True
意義相同
參考資料:https://msdn.microsoft.com/en-us/library/ff647396.aspx
