SQL Express 2016(一)安装以及c#的连接

1.下载

SQL Express 2016下载

https://www.microsoft.com/en-us/sql-server/sql-server-editions-express

 

SQL Express 2016 SMSS(SQL Server Management Studio)下载

https://msdn.microsoft.com/library/mt238290.aspx

 

2.在windows上使用c#创建连接sql的应用

https://www.microsoft.com/en-us/sql-server/developer-get-started/csharp-windows

 

                SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
                builder.DataSource = ".\\SQLEXPRESS";   // 打开SMSS，可以看到Servername有XXX\SQLEXPRESS
                builder.UserID = "sa";              // update me
                builder.Password = "your_password";      // update me
                builder.InitialCatalog = "master";

3.使用network service登录SMSS时报错

https://social.technet.microsoft.com/Forums/en-US/b8b3daa8-b388-49f4-91f3-75e37a4b2253/nt-authoritynetwork-service?forum=sqlserverzhchs&forum=sqlserverzhchs

打开SMSS，单击Security 和Logins，但是也没有找到NT AUTHORITY\NETWORK SERVICE这个用户，后来只能使用sa用户，更改密码后，在status的page中选择 Login Enabled.