C#连接SQL Server 2000出现项“integrated security”的值无效

Question

数据库连接代码： 

SqlConnection conn = new SqlConnection("server=(local);" + "Database = Northwind;" + "Integrated Security=ture;");
        conn.Open();
        SqlCommand cmd = new SqlCommand("select * from userinfo", conn); //userinfo是数据库表名称
        SqlDataReader reader = cmd.ExecuteReader();

Answer 1

Integrated Security=SSPI

或者

Trusted_Connection =true

 

---

family as water

Answer 2

你好！

     你的连接字符串写的有点问题，这样修改一下：

SqlConnection conn = new SqlConnection("server=(local);" + "Database = Northwind;" + "Integrated Security=SSPI;");

---

周雪峰