locked
System Administrator Database Role in SQL 2008 R2 RRS feed

  • Question

  • Dear Sir.

    I am doing a configuration for RMS Server, However in artical: http://technet.microsoft.com/en-us/library/cc771789.aspx, They are asking to  the user account must be a member of the System Administrators database role, or equivalent.

    In sql 2008 R2 I have the following roles: blukadmin, dbcreator, diskadmin, processadmin, public, securityadmin, serveradmin, setupadmin, sysadmin.

    Please I want to know which one is the real System Administrator database role?

    Awaiting your reply

    Thanks

    Thursday, December 30, 2010 7:42 AM

Answers

  • SysAdmin
    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
    • Proposed as answer by Crazy Adam Friday, December 31, 2010 6:31 PM
    • Marked as answer by WeiLin Qiao Tuesday, January 11, 2011 10:10 AM
    Thursday, December 30, 2010 7:58 AM

All replies

  • SysAdmin
    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
    • Proposed as answer by Crazy Adam Friday, December 31, 2010 6:31 PM
    • Marked as answer by WeiLin Qiao Tuesday, January 11, 2011 10:10 AM
    Thursday, December 30, 2010 7:58 AM
  • Dear Sir.

    I am doing a configuration for RMS Server, However in artical: http://technet.microsoft.com/en-us/library/cc771789.aspx, They are asking to  the user account must be a member of the System Administrators database role, or equivalent.

    In sql 2008 R2 I have the following roles: blukadmin, dbcreator, diskadmin, processadmin, public, securityadmin, serveradmin, setupadmin, sysadmin.

    Please I want to know which one is the real System Administrator database role?

    Awaiting your reply

    Thanks

    Dear I Did the following:

    1- select to ADd a new Login, I search in AD and I select the user I want in General Page

    2- in Server Roles Page I select dbcreator

    3- I clicked ok

    Do you think this steps are enough to grant what asked in artical for System ADministrator Database?

    Thanks

    Thursday, December 30, 2010 8:06 AM
  • MS has removed BUILTIN\Administrators , so please create a new domain user and grant him to be member of sysadmin server role
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    Thursday, December 30, 2010 8:08 AM
  • In Server Roles page, you need to choose SysAdmin


    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
    Thursday, December 30, 2010 8:10 AM
  • I once tried, is possible.
    http://social.msdn.microsoft.com/profile/kissmen/?type=forum
    Thursday, December 30, 2010 8:14 AM
  • In Server Roles page, you need to choose SysAdmin


    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


    When I am using Domain adminstrator I am able to find the instance on server and see the databases, BUT on the domain user and After assigning the cridential sysadmin,dbcreate, and serveradmin I still not able to get the instaance from the server and see the Databases.

    I am getting this error:

    SQL Server was not detected on 'server' verify that the remote coompoouter is operating normally ans that it is accessible from the network, and then try to connect again.

    Any suggestion

    Thursday, December 30, 2010 8:38 AM
  • its not due to permission, its due to networking
    Please follow steps given here http://support.microsoft.com/kb/914277

    Ping me at blakhani (at) koolmail (dot) in for quick help.
    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
    Thursday, December 30, 2010 9:14 AM
  • its not due to permission, its due to networking
    Please follow steps given here http://support.microsoft.com/kb/914277

    Ping me at blakhani (at) koolmail (dot) in for quick help.
    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


    I have SQL 2008 R2, not 2005

    Also its permission issue, not network, coz domain admin can aceess, but domain user cannot

    Thursday, December 30, 2010 9:39 AM
  • Ah. i didnot notice that domain admin can access.
    I would suggest to run profiler trace to see the actual SQL Error because "SQL Server was not detected on 'server' verify that the remote coompoouter is operating normally ans that it is accessible from the network, and then try to connect again." is NOT SQL native error.


    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
    Thursday, December 30, 2010 9:45 AM