Mapping a user to a login

Hot Topic

join queries
Trying to Configure For Loop Container
Error grouping in Pivot table with OLEDB for Analysis Servises 9.0
Select between ???
AutoClose
SQL CE Push ConnectTimeout
SQL Server 2005 Service Pack 1 CTP March 2006 available
SQL Transact: Subquery
Is Point in time recovery the same in all versions of SQL Server 2005?
Installation of SQL Server 2005 Express Edition

SQL Server

Debugging SP On server from workstation using Query Analyzer
can't install sample databases plus no documents or tutorials
Configuration files and variables
Convert Rows into Columns... (Cross tab).
execute SQL task with in a For Each Loop
where is the "render" method in 2005? Immediate help needed..!
Locking up after SQL Server Mobile Merge Replication
Keyset does not exist
Dataset and Filters
Sql server CONNECTION STRING...

Mapping a user to a login

I have created a login and a user on a database using SMO. I am having trouble mapping a database to the login. When you create a login from the GUI using SQL Server Management Studio Express CTP the user is automatically created and the database is mapped to this login from the user mapping tab. When I create the login programmatically this is not the case so I need to create the user.  How do I map the database to the login. I set the default database property on the login but this does not do it.

Thanks,

Michael Gustafson

 

Answer this question

Mapping a user to a login

  • Dave B..

    what property of the Login is used to show what databases are mapped

    also is there a way with SMO to check and see if a password is blank Granted the odds of that are extemely slimmer with 2005.

  • jjswildfire

    This is the pattern you would normally follow (this is for a windows user, but it works the same for a SQL user):
     

    Login l = new Login(svr, @"REDMOND\mwories");
    l.LoginType =     LoginType.WindowsUser;
    l.Create();

    Database db = svr.Databases["AdventureWorks"];

    User u = new User(db, @"REDMOND\mwories");
    u.Login = l.Name;
    u.UserType =     UserType.SqlLogin;
    u.Create();

    This maps the database user to the login as you create the login.
     


  • Lee_Dale

    I found the DatabaseMapping() class and was able to find which logins were missing mappings. Im still at a lost at how to test for blank passwords using SQL2005 and SMO.

    Thanks for taking time to read this.

    Chuck Turner
  • Mapping a user to a login
Answer this question