Adding new SharePoint ProjectServer to Farm Issue


SharePoint 2010 farm with multiple servers in web and App layer. You want to add a new Web server for Microsoft SharePoint / Microsoft Project Server, and SharePoint Configuration fails on the new server. The farm has been running Sharepoint 2010, MS Project Server 2010, Office Web Apps and Language Packs. 
Error Message:
SharePoint Products Configuration Wizard brings the following message after you select the SQL Database server and then the SharePoint Farm Configuration DB.
Server Farm Products and Patch Status
The following SharePoint Technologies based products and patches were detected on your server farm.

Some farm products and patches were not detected on this or other servers. If products or patches are missing locally, you must quit this program and install the required products and patches on this server before restarting the wizard. If products or patches are missing on other servers, you must install the required products and patches on the specific servers, and you may then click the Refresh button to perform the status check again.

Scroll down the list and you will see other updates as missing as well. In my case it listed the following updates as missing on three existing servers and the new server.
Server Farm Products Status
1. Microsoft Word Server
HotFix for Sharepoint Server 2010 x64    Missing on SPServer01, 02 and 03
Security Update for Sharepoint 2010        Missing Locally [SPServer07new]
2. Excel Services Components
Hotfix for Sharepoint 2010 x64              Missing on SPServer01, 02 and 03
Security Update for Ms Sharepoint X64 Missing Locally [SPServer07new]
3. Access Services
Hotfix for Sharepoint 2010 x64 Missing on SPServer01, 02 and 03
Security Update for 2010 MS Business Missing Locally [SPServer07new]
Productivity Servers
The error listed basically the MS KB 2825949 patch as missing on all existing servers. That error was misleading. That patch was existed on existing servers.
I then looked for the three patches on local server – i.e the new server. The local server was missing these updates:
The new server is missing three MS KB updates.
a. KB2826029 – Excel Services Update
b. KB2553298 – Access Services / MS Business Productivity Update
c. KB2837577 – Word Automation Service Update
I went to Microsoft Knowledge base (KB) article page for KB 2826029 – Excel Services Patch to begin with.
There wasn’t a patch download link on that KB article. I went to the IT Professional page link on that KB article and that took me to Under ‘Affected and Non-Affected Software’ section, click the link for the SharePoint 2010 server SP2 related links. There are links for WSS, Excel Services, Word Automation. In our case the missing update KB number matches the Excel update 2826029. I downloaded and installed the Excel update. The same way I found the other two patches.
KB2826029 – Excel Services Patch – Download Link
KB2553298 – Access / Business Productivity – Download Link
KB2837577 – Word Automation Service – Download Link
I re-ran the Sharepoint Configuration wizard and it completed successfully. New Server was now part of the farm. 
Final Conclusion:
In my case, it was key to pay attention to ‘Missing Locally’ patches in the error screen. I confirmed the missing patches on new server by using Control Panel > Uninstall a Program > View Installed Updates section.
Some blogs suggest running following command to fix the issue. In my case, those smaller patches were indeed missing.
Get-SPProduct –local
psconfig -cmd installcheck -noinstallcheck
psconfig -cmd upgrade -inplace b2b -force -cmd -installcheck -noinstallcheck

One Response

  1. I think this is among the most significant info for me.
    And i’m glad reading your article. But should remark on some general things, The web
    site style is great, the articles is really excellent : D.
    Good job, cheers

Leave a Reply

Sign up for Softvative Newsletter

Get notified about new articles and deals

Receive the latest technology and leadership news and resources from us

Subscribe To Softvative Newsletter