SharePoint 2010 + AD FS 2.0 + Project Server 2010 = lost time, productivity and money.

For those of you that are not aware, SharePoint 201 and AD FS 2.0 do not play nicely with Project Server 2010. It is a known Microsoft bug that the Project Server 2010 AD Sync does not work when AD FS 2.0 (SAML Authentication) is in use on the SharePoint web application that houses the Project Server PWA site. What is the fix? Besides upgrading to the 2013 versions of all the respective products, there isn’t one. The “band-aid” is to disable AD FS, the SAML Authentication provider, on the web application to allow the Project Server 2010 AD Sync to complete successfully.

<sarcasm>But wait, it gets better!</sarcasm>

From a clean installation of SharePoint 2010, everything is normal. Next, install Project Server 2010 and provision the PWA site. Again, normal. Access to the SharePoint site(s) works properly through the browser and depending on the permissions set on the PWA site, it can be access through the browser as well. At this point, you should be able to connect Project Professional to the PWA site by configuring the server account. Here’s where the trouble comes in. During the configuration of AD FS 2.0, a number (10 to be exact) PowerShell scripts need to be run in order to assign the three levels of the SSL certificates (root, intermediate and multi) to variables, import the certificates to SharePoint and then finally create and enable the authentication provider in SharePoint. This may as well set your Project Professional clients on fire. They will not connect. They do, however, leave you with a lovely and descriptive message of, “Could not retrieve server initialization data.” then proceeds to ask, “Was this information helpful?” Thanks Microsoft, NO, IT WAS NOT HELPFUL. So, this is where we sit, with yet another Microsoft Support ticket open and the ongoing war of me firing logs and information at the support engineers and them firing back useless things to try. I’ll update this post if a solution is found during my last week of work there, but it doesn’t look hopeful.


December 4th, 2019

SQL Puzzle

In my endless search for the end of the internet, I stumbled across a fun SQL Puzzle.  Link:  

October 25th, 2019

New Power BI Calendar Table

While the old one still works, it doesn’t exactly follow Power BI and DAX best practices. Much like everything in […]

March 5th, 2019

Power BI Report Last Data Refresh Date & Time Tile

With all the data flowing within companies, we needed a way to track the last time Power BI reports were […]

December 3rd, 2018

Date Table and Extras for Power BI

When dealing with incomplete date sets in Power BI, I often add in a quick and dirty Data table to […]

February 14th, 2018

Invincible workflows

Today I encountered a list item that had two instances of the same workflow, both stuck on the first step. […]

May 17th, 2017

The case of the missing App Launcher

Today I deleted and recreated a SharePoint 2016 Web application and recreated it, without issue. Well, except that the new […]

March 10th, 2017

The server failed to process the request. Aka, the SharePoint version of PCLoadLetter

It’s Friday so I’ll keep this short The ongoing power struggle between SharePoint and it’s tamers continues. Today we’re faces […]

March 3rd, 2017

Search, search, search, all the day long…

So, I just rolled SharePoint 2016 into a test environment and launch Central Admin, and the first thing my eyes […]

May 5th, 2016

Oh, happy day!

SharePoint 2016 has been released to MSDN! Time to practice different upgrade strategies and see what this baby can do! […]

March 29th, 2016

Branding Gone Wild

Today I ran into a problematic sub-site in my SharePoint 2013 farm. This sub-site, named “Test”, was where I had […]