Permission required for installing FIM DB other that 'Sysadmin' RRS feed

  • Question

  • Hi ,

    I have scenario where SQL is on named instance and due to complience i am not getting sysadmin rights for installing/creating FIM db's.

    But i need to install FIM Sync and FIM Service and portal without sysadmin rights

    What permissions do i need to have on SQL if not sysadmin?

    VM1: SQL 2008 SP2

    VM2: FIM server

    Wednesday, October 31, 2012 4:04 AM


  • Hi,

    Look at the Installation Guide: Installing the FIM 2010 R2 Server Components

    You must use an account with local administrator privileges to install the Microsoft® Forefront® Identity Manager (FIM) 2010 R2 server components. To be able to install the FIM Portal, the account must be a SharePoint administrator. To be able to install FIM Synchronization Service or FIM Service, the account must be a SQL sysadmin. The account that you use does not have to be a SQL sysadmin after the installation is complete.


    Patrick Layani

    Sunday, November 4, 2012 4:13 PM