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

Fast Search for SharePoint 2010: Crawl running but not crawling content

This is an oldie but goodie in the sense that I just resolved this yesterday but my customer is still on SharePoint 2010 and FAST Search 2010. They are nostalgic what can I say Symptoms were that the crawl would run for hours but nothing was logged in the crawl log Problem #1 I looked…

0

PowerPivot 2008 R2 and SharePoint 2010: We cannot locate a server to load the workbook Data Model

Problem: Customer was experiencing the error below when trying to view a PowerPivot workbook in their SharePoint site. This was only occurring in their production farm. I also found this error in the logs: Troubleshooting: verified they had the SQL Server analysis service instance enabled on the PowerPivot/SharePoint server (problem still occurred) verified that their…

1

PowerPivot for SharePoint: Failed to render chart

Problem: on a SharePoint 2010/PowerPivot 2008 R2 environment, users would receive a 'Failed to render' chart' error Troubleshooting: Based on previous experience I tried the following but all came back negative Is PowerPivot feature enabled at the site collection? Yes Recycled app pools – error still occurs Verified that CT2WTS is enabled on every server running…

0

SharePoint 2010: Who is deleting my workflows??!!

Problem: The issue was that someone with SharePoint Designer access deleted some workflows. No one stepped forward to claim responsibility so I was tasked with trying to track down who did and provide a solution to prevent this. A quick side-bar, this is why I recommend a training curriculum for your users BEFORE they are…

0

Project Server 2010 errors when trying to input new Issues and Risks after migration from Project Server 2007

Problem: User is receiving a correlation ID when trying to access a PWA of a newly migrated site. This problem was limited to 2 sites in my case. Resolution: After discussing with my Project Server colleague, this can occure on project sites exported from Project Server 2007 and imported into Project Server 2010 when they do not have…

0

SharePoint 2016 on-premises update Ignite recap

HI everyone, I was fortunate enough to attend the Ignite conference last week in Chicago it was a good time, lots of good news we're coming out with. I highly recommend watching the Bill Baer sessions on SharePoint 2016 on Channel9 that I have listed at the end of this post. I also attended a…

7

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…

6