none
HPC R2 Database permissions RRS feed

  • Question

  • We are deploying a small HPC cluster. In the documentation the permission level required for logins used by hpc to access databases is 'sys admin role' on the SQL server. We want to host the databases on a shared SQL instance and we dont want to use sys admin level access. Is there any way around it or do we need to use sys admin access level?
    Thursday, April 28, 2011 1:32 PM

Answers

  • In the documentation found at http://technet.microsoft.com/en-us/library/ee783548(WS.10).aspx it talks about adding additional HPC system administrators and why the sysadmin server role is required:

    "After you perform the installation, if you add an HPC administrator to the cluster, ensure that a SQL Server login for the domain account is created on each SQL Server instance that you configured for the HPC databases and that the sysadmin server role is assigned to the login, as explained in Step 1: Prepare the Remote Database Servers. This is necessary for the HPC administrator to use features that access the reporting database and to be able to reinstall, update, or upgrade HPC Pack 2008 R2. If the remote database servers are not managed by you, contact the administrator of those servers for assistance with this task."

     

    So to answer your question - yes you need the sysadmin server role.

     

    I know you only have a small cluster - but having the databases on shared SQL instances may also lead to performance issues.

     

     

    • Proposed as answer by Mark Staveley Wednesday, May 4, 2011 1:38 AM
    • Marked as answer by Vega1x1 Friday, June 24, 2011 2:43 AM
    Friday, April 29, 2011 12:53 AM

All replies

  • Have you reviewed the docuymentation for setting up HPC with a Remote Database?  http://technet.microsoft.com/en-us/library/ee783551(WS.10).aspx  Is this the documentation you are talking about above?

     

    Thanks,

    Mark

     

    Thursday, April 28, 2011 6:36 PM
  • yes and specifically the following line:

    Assign the sysadmin server role for the instance to all the logins that you created for the HPC cluster. For more information, see Server-Level Roles (http://go.microsoft.com/fwlink/?LinkId=173275).

    thank you

    Thursday, April 28, 2011 7:49 PM
  • In the documentation found at http://technet.microsoft.com/en-us/library/ee783548(WS.10).aspx it talks about adding additional HPC system administrators and why the sysadmin server role is required:

    "After you perform the installation, if you add an HPC administrator to the cluster, ensure that a SQL Server login for the domain account is created on each SQL Server instance that you configured for the HPC databases and that the sysadmin server role is assigned to the login, as explained in Step 1: Prepare the Remote Database Servers. This is necessary for the HPC administrator to use features that access the reporting database and to be able to reinstall, update, or upgrade HPC Pack 2008 R2. If the remote database servers are not managed by you, contact the administrator of those servers for assistance with this task."

     

    So to answer your question - yes you need the sysadmin server role.

     

    I know you only have a small cluster - but having the databases on shared SQL instances may also lead to performance issues.

     

     

    • Proposed as answer by Mark Staveley Wednesday, May 4, 2011 1:38 AM
    • Marked as answer by Vega1x1 Friday, June 24, 2011 2:43 AM
    Friday, April 29, 2011 12:53 AM