- C# code
public bool AddUser(string cUserName,string Password,string DB) { System.Data.SqlClient.SqlConnection oCon=new System.Data.SqlClient.SqlConnection("data source=.;initial catalog=master;password=123456;persist security info=True;user id=sa"); try { oCon.Open(); } catch { return false; } System.Data.SqlClient.SqlCommand oAddUser=new System.Data.SqlClient.SqlCommand(); oAddUser.CommandType=System.Data.CommandType.Text; oAddUser.Connection=oCon; oAddUser.CommandText="exec sp_addlogin '"+cUserName+"','"+Password+"','"+DB+"'"; int i=oAddUser.ExecuteNonQuery(); if(i==0) { return false; } else { return true; } } private void button1_Click(object sender, EventArgs e) { AddUser("abcde","1234","master"); }
现在调用sp_addlogin新建用户名ABcde,密码为1234 但是默认强制实施密码策略是打上钩的,该怎么样通过编程技术让他不打钩呢?
------解决方案--------------------
创建用户取消密码策略及使用期限
- SQL code
CREATE LOGIN [BaseUser] WITH PASSWord=N'baseuser',DEFAULT_DATABASE=[TRS],CHECK_EXPIRATION=OFF, CHECK_POLICY=OFFGO
------解决方案--------------------