Is there any sample code which creates login and user of one database using SMO?

Is there any sample code which creates login and user of one database using SMO?

• Aaron Winters

  Hi,
  
  sorry the same day you posted the question I wrote quick application, I imported that in a q&d Winform solution, which might help you to see the way to do it:
  

  http://www.sqlserver2005.de/SharedFiles/UserMappingwithSMO.zip
  
  
  HTH; Jens Suessmeyer.

  ---
  http://www.sqlserver2005.de
  ---

  
  

• alan lan

  My bad, I was reading this topic in reverse date order and just noticed that another thread asked a similar question and got basically the same response.

  http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=195387&SiteID=1

  
  

• LabibaSeif

  Here's a sample, you can build from it to allow for creation of group or other login types, etc.

  Set up connection to server and database:

  _srv = new Server(@"MySqlServer\Instancename");

  _dbname = @"MyDatabase";

  _db = _srv.Databases[ DBName];

  Login lgn = new Login(_srv, @"domain\username");

  lgn.DefaultDatabase = _dbname;

  lgn.LoginType = LoginType.WindowsUser;

  lgn.Create();

  User usr = new User(_db, @"MyUserName");

  usr.Login = loginId;

  usr.Create();

  --Stan

  
  
• Is there any sample code which creates login and user of one database using SMO?