locked
Msg 10011, Level 16, State 1, Line 1 RRS feed

  • Question

  • I received the error Msg 10011, Level 16, State 1, Line 1 when i try to add server role like sysadmin a login. kindly help
    Omojuwa Raymond
    • Moved by Tom Phillips Monday, April 11, 2011 5:21 PM Security question (From:SQL Server Database Engine)
    Friday, April 8, 2011 9:28 AM

Answers

  • Only members of the "sysadmin"  role, can add other users to "sysadmin".

     

    • Proposed as answer by WeiLin Qiao Wednesday, April 13, 2011 6:37 AM
    • Marked as answer by WeiLin Qiao Monday, April 18, 2011 10:50 AM
    Monday, April 11, 2011 5:21 PM

All replies

  • Maybe could be helpful this post: http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/139514aa-cece-4997-a08f-c7ea3f7cdd3a/
    Friday, April 8, 2011 9:30 AM
  • Select * from sys.messages where message_id = 10011

    Access denied.


    Try Run As Administrator
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Friday, April 8, 2011 1:33 PM
  • Only members of the "sysadmin"  role, can add other users to "sysadmin".

     

    • Proposed as answer by WeiLin Qiao Wednesday, April 13, 2011 6:37 AM
    • Marked as answer by WeiLin Qiao Monday, April 18, 2011 10:50 AM
    Monday, April 11, 2011 5:21 PM