I have some problem when restoring an AppSet in Server Manager. It seems to keep hanging at "create OLAP database" stage. The first 3 steps which is Webfolder, FileDB and SQL database had completed.
Currently, we have 2 servers for BPC environment which is GSPPBPC server and GSPPBPCDB server. Let me summarize on what are the components I had installed to these servers:
SQL Server: GSPPBPCDB
OLAP Server: GSPPBPCDB
Insight OLAP Server: GSPPBPCDB
File Share Server: GSPPBPC
Reporting Services Server: GSPPBPCDB
Application Server: GSPPBPCDB
Web Server: GSPPBPCDB
For your information, I'm opening the Server Manager from GSPPBPC server.
The installation process completed successfully. Is there any OLAP port that need to be opened between these 2 servers? Please advise what went wrong.