private static void CreateLogin(Server server, NamedSmoObject db, string loginName)
{
var login = new Login(server, loginName)
{
DefaultDatabase = db.Name, LoginType = LoginType.WindowsUser
};
login.AddToRole("sysadmin");
login.Create();
}
private static void CreateLogin(Server server, NamedSmoObject db, string loginName)
{
var login = new Login(server, loginName) { DefaultDatabase = db.Name, LoginType = LoginType.WindowsUser };
login.AddToRole("sysadmin");
login.Create();
}
public void CreateLogin(string name, string password, string defaultDatabase, string[] roles)
{
Login login = new Login(_server, name)
{
LoginType = LoginType.SqlLogin,
DefaultDatabase = defaultDatabase,
PasswordExpirationEnabled = false,
PasswordPolicyEnforced = false
};
login.Create(password, LoginCreateOptions.None);
for (int i = 0; i < roles.Length; i++)
login.AddToRole(roles[i]);
login.Alter();
login.Enable();
login.Alter();
}
