常用链接字符串

Data Source = myServerAddress;Initial Catalog = myDataBase;User Id = myUsername;Password = myPassword;

 

Server = myServerAddress;Database = myDataBase;User ID = myUsername;Password = myPassword;Trusted_Connection = False;

 

信任连接

Data Source = myServerAddress;Initial Catalog = myDataBase;Integrated Security = SSPI;

Server = myServerAddress;Database = myDataBase;Trusted_Connection = True;

 

Data Source = .\SQLExpress;Integrated Security = true; AttachDbFilename = |DataDirectory|\mydb.mdf;User Instance = true;

 

Server=.\\SQLSERVER0409;Database=basic;Trusted_Connection=True;MultipleActiveResultSets=true