Does Secure Store go on a separate SQL Serever or just a separate Named Instance? RRS feed

  • Question

  • I see in ee806889, "Plan the Secure Store Service (SharePoint Server 2010)", this line:

    "Create the secure store database on a separate application server running SQL Server. Do not use the same SQL Server installation that contains content databases."

    QUESTION:  Does MSFT mean I need a separate SQL Server License and Installation, or merely do I need separate Named Instances (one for Content Databases and one for Secure Store Service) on the same SQL Server License and Installation???


    Monday, October 10, 2011 3:11 PM


  • Hi,

    The secure store service preparation section in "Plan the Secure Store Service (SharePoint Server 2010) " is the best solution to deploy secure store service to seperate modules and improve the risk control.

    In my opinion, you don't have to install another sql server on another server. you can use the same sql server instance with the content databases.

    Seven Ma

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tnmff@microsoft.com 

    • Edited by Seven M Tuesday, October 11, 2011 7:31 AM
    • Marked as answer by Wayne Fan Wednesday, November 9, 2011 1:39 AM
    Tuesday, October 11, 2011 7:26 AM