Powerpivot and the Unattended Service Account

My customer had a tough time understanding how the Unattended Service account relates to the actual PowerPivot workbooks. This specific scenario was Powerpivot 2012 and SharePoint 2013. Quick shout out to my colleague Rick Andring for all the help he provided in helping my customer understand all of this stuff. His teams’ blog can be…

0

SharePoint 2013 and PowerPivot 2012: why are there so many data model databases?

Problem: My customer sent me a screenshot of their SQL Server Management studio Analysis Services database listing. They were concerned with one of the database model tables appearing multiple times, in this case around 20 times. They asked me how can they determine which of these copies is the one that is active? Just so…

0

SP 2013: RMS Configuration not working: The required Active Directory Rights Management Service Client (MSIPC.DLL) is present but could not be configured properly. IRM will not work until the client is configured

Problem: Every time customer tried to configure SharePoint to connect to the AD RMS server this error would appear We verified that these two files had proper rights, at first they did not: https://rmsserver/_wmcs/certification/certification.asmx and https://rmsserver/_wmcs/certification/servercertification.asmx   Log on to ADRMS server as an Administrator. Click Start, and then click Computer. Navigate to C:\Inetpub\wwwroot\_wmcs\Certification. Right-click…

7

Update on InfoPath: Will be supported in SharePoint 2016 and Office 365

Lots of my customers have been asking about the future of InfoPath. Especially after it was announced that it was going to be deprecated. Looks like it will be around for the near future in both the next version of SharePoint and Office 365 Per the Office Blogs site: http://blogs.office.com/2014/01/31/update-on-infopath-and-sharepoint-forms/ As part of the update…

1

SharePoint 2013: Cannot Remove Server from Farm: cacheHostInfo is Null

Problem: Customer was trying to remove a server from the farm via the ‘Remove Server’ link in Central Administration. Every time they would try this, they would receive an error that said ‘cacheHostInfo is Null’ Troubleshooting: Right away, from experience, I knew this had to do with improper removal of a server from a farm…

5

SP 2013: Help links in Central Admin not working: there is a compatibility range mismatch betwwn the web server and database "CentralAdmin_Content"

Problem: When clicking on the Help links in Central Ad,min ” There is a compatibility range mismatch between the Web server and database "CentralAdmin_Content", and connections to the data have been blocked to due to this incompatibility. This can happen when a content database has not been upgraded to be within the compatibility range of…

0

SharePoint Conference 2014: what do you want to know?

HI everyone, I will be attending the SharePoint conference next week. For those of you who have been there, I'm sure you'll agree its an amazing experience. This will be my 2nd time attending. I'm looking forward to the many sessions and finally meeting some of you. For those who are not attending, what do…

0

SharePoint 2013: Workaround: Cannot add web part to Community Portal page

Requirement: Customer wants to add a Content Editor web part to Community Portal page  Problem: When user clicks on the Gear icon>> ‘Edit Page’, then clicks ‘Add a Web Part’ there is no response  Workaround: Below is an out-of-the-box workaround.  Create a ‘Web Part Page’ (via     SPD 2013 (SharePoint Designer 2013) or the GUI).           NOTE: It…

3