none
Azure SQL database as DB for MIM 2016? RRS feed

  • Question

  • Hey guys, 

    Is it supported or even possible to use an Azure SQL database as the DB for the MIM Service?



    Andreas Hultgren<br/> MCTS, MCITP<br/> <a href="http://ahultgren.blogspot.com/">http://ahultgren.blogspot.com/</a>

    Sunday, March 4, 2018 2:44 PM

Answers

  • Hi A.Hultgren,

    Right now you can only connect Management Agents to DB that is stored on Azure SQL. There is no workaround and it is not supported that either of FIM/MIM or SharePoint DB would be installed on PaaS DB. Right now you have to use "on-prem SQL Server" wherever the server is installed - it can be server itself or VM either on-prem or as IaaS.


    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.


    Tuesday, March 6, 2018 11:25 PM

All replies

  • yes it is.

    Nosh Mernacaj, Identity Management Specialist

    Sunday, March 4, 2018 3:50 PM
  • Which one? Supported or possible? (Also, do you by any chance have a reference?) 

    Andreas Hultgren<br/> MCTS, MCITP<br/> <a href="http://ahultgren.blogspot.com/">http://ahultgren.blogspot.com/</a>

    Sunday, March 4, 2018 4:02 PM
  • Both. I dont think it is explicitly stated as Azure but it is understood

    Nosh Mernacaj, Identity Management Specialist


    Sunday, March 4, 2018 5:44 PM
  • Basically, the requirement is around SQL version, not the platform. SQL can be on prem or Azure, does not matter.

    Nosh Mernacaj, Identity Management Specialist

    • Proposed as answer by Nosh Mernacaj Monday, March 5, 2018 5:59 PM
    • Unproposed as answer by Nosh Mernacaj Monday, March 5, 2018 10:29 PM
    Monday, March 5, 2018 5:59 PM
  • All right, but just to make sure we're talking about the same thing, my question is regarding the "Azure SQL Database" service, not SQL Server running on a VM in Azure. 

    Andreas Hultgren<br/> MCTS, MCITP<br/> <a href="http://ahultgren.blogspot.com/">http://ahultgren.blogspot.com/</a>

    Monday, March 5, 2018 10:16 PM
  • That is a different question, sorry for the misunderstanding.

    Nosh Mernacaj, Identity Management Specialist

    Monday, March 5, 2018 10:28 PM
  • Hi A.Hultgren,

    Right now you can only connect Management Agents to DB that is stored on Azure SQL. There is no workaround and it is not supported that either of FIM/MIM or SharePoint DB would be installed on PaaS DB. Right now you have to use "on-prem SQL Server" wherever the server is installed - it can be server itself or VM either on-prem or as IaaS.


    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.


    Tuesday, March 6, 2018 11:25 PM
  • Yeah, I was looking into this a bit more last night, and going through the wizard is clearly states that it will connect to the SQL server using windows authentication (currently logged on user), which of course can't authenticate to the Azure SQL database (not sure if it could if you were logged on with an Azure AD account). 

    So I'm afraid the answer is no to this one, right now at least. 


    Andreas Hultgren<br/> MCTS, MCITP<br/> <a href="http://ahultgren.blogspot.com/">http://ahultgren.blogspot.com/</a>

    Wednesday, March 7, 2018 6:46 AM
  • You cant do that because the installation account needs to be a Domain Account and becomes the SharePoint Farm Admin and MIM Admin.

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, March 7, 2018 2:49 PM
  • Hi Nosh,

    All those accounts can be divided, that's not a problem to run FIMPortal install with another account that FIMSync install. So please don't say that this account automatically becomes SP Farm Admin and MIM Admin.

    There are a couple of problems like no 1ms latency guaranteed for SharePoint or SQL Agent that is needed for FIMService DB.


    If you found my post helpful, please give it a Helpful vote. If it answered your question, remember to mark it as an Answer.

    Wednesday, March 7, 2018 5:59 PM
  • No where did I say FIMSynchInstall. I guess there is a missunderstanding, however, the answer to the question is still not possible

    Nosh Mernacaj, Identity Management Specialist

    Wednesday, March 7, 2018 6:46 PM
  • it's been over a year since this was asked.  Has anything changed? can we use Azure PaaS SQL solution for the MIM sync and service databases?
    Thursday, May 30, 2019 12:28 PM