locked
Database doesn't show username even when user mapping to DB is set RRS feed

  • Question

  • Hello All,

    I have wierd problem,  On this SQL server I am sysadmin. I created a DB and assigned the my username through the user mapping of the SQL server -- security folder for the newly created database.

    But, my user name does not show up in the databases --> users folder??????

    Can anyone point me in the direction to fix this, I have done several refreshes.

    Monday, January 31, 2011 9:13 PM

Answers

  • When a login is sysadmin in SQL server it doesnt need access to databases through user mapping but there is no harm in doing that. I am sure this should work and you should be able to see them in the users immediately.

    Did you query sys.database_principals catalog on that database ? Are you in the right database when checking in GUI ?


    Thanks, Leks
    • Proposed as answer by WeiLin Qiao Thursday, February 3, 2011 6:43 AM
    • Marked as answer by WeiLin Qiao Wednesday, February 9, 2011 9:36 AM
    Tuesday, February 1, 2011 12:09 AM