I am in the process of deploying Performance Point but hesitating now after reading this
Microsoft advise :-
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
Does this REALLY mean I have to find a separate middleware server, deploy this service and run a separate SQL server with just this database on it ? Has anyone deployed this service successfully on a WFE on a simple farm configuration.
Also, they recommend using Kerberos authentication to authenticate individual accounts, but my understanding is that if I have Sites which are not on the default ports (80 and 443), the CRAWL service will fail - it will only work on non-default ports using NTLM ? Seems to be a CATCH 22 !!!
I am proposing to set this service up on the WFE in common with all other services (it is fairly meaty 16GB box), and either :-
1. Create the database within the current SQL instance (which also contains the content and config databases)
2. Create a new SQL instance and create this database for the Secure Store ONLY on the new instance.
All recommendations welcomed !!