I been trying to install the web services for one of my clients, they are running a complicated environment, clustered SQL Server environment over three servers and clustered Hyper-V server to manage virtualized web applications like Workflow and Business Portal.
We have installed the SharePoint Server Farm and configured the Load Balancer to manage the load balancing between servers and created web applications for both Workflow and Business Portal and then moved to the web services installation which was already installed on the production environment, unfortunately the installation never succeeded with the above error message.
I tried everything, reinstalled it more that 100 times with no luck, searched every where with no result where I realized that the web services cannot be installed on a multiple server environment which does not make sense.
Finally I have decided to select the same Web Services database of the production environment and it worked! Looks like the Web Services cannot be installed with more that security database which is logically right due to the complication of the security roles and tasks on the web services entities.
Next time do not waste your time and directly select one name for web services database!
Mohammad R. Daoud MVP - MCT
MCP, MCBMSP, MCTS, MCBMSS
+962 - 79 - 999 65 85