SharePoint 2013 Unable to Open Documents from Ribbon when WOPI is Configured and Library Default open behavior for browser-enabled documents is Open in the client application

It appears to be an IE issue when clicking on the New Document Drop down from the ribbon using fiddler4 there are not any results returned, probably jscript or jquery … I am running IE11 and I have tested IE10 which exhibits the same behavior. I haven’t tested on earlier versions yet.

However, if you open with Mozilla the Microsoft Office is blocked until you Allow Mozilla to open Office Documents and then Default open behavior for browser-enabled documents works as expected. In other words when the library is set to open ion the browser (via WOPI) the documents open in the browser, when set to open in the client application, the docs open in the client as expected..

Click On Allow


Then choose to Allow remember


Then choose OK,



Click on New Document one more time to open from the ribbon



Note: this only occurs if you have WAC installed and configured WOPI with SharePoint. Also, you only have to go to library settings to set the Default open behavior for browser-enabled documents: to Open in the client application, you don’t have to set the site collection… I will resolve as time permits






Embed a PowerPoint Presentation into a SharePoint 2013 Page with Multiple Farms

It seems like everyone NothingButSharePoint and Microsoft Office and Microsoft Bogs states that you can not embed unless your using Office 365 (this may have been due to using SharePoint 2010). There are many more post and articles that require you to use Onedrive.. There are probably many better ways to sharing Content using WAC with multiple farms and SharePoint On-Prem and I would enjoy hearing about how you have solved this issue

Embed a PowerPoint Presentation from a source SharePoint Farm and render the presentation in a target SharePoint Farm using CEWP

1. Go to and search for PPTX


2. Use the Drop Down, Choose embedded information, and Copy All

3. Go to

5. Add Content Editor WebPart





6. Click Inside the WebPart Choose the Orange Insert, Click Embed Code


7. Insert (Paste CTRL+V) the Code you copied from


8. Then Click the Insert button,

9. Next Edit the WebPart, and change the Width to 540px, then click OK


10. Click Check-in, then Publish this Draft




Note: The Site Collection Feature – Cross-Farm Site Permissions is activated on both Farms, the cross-farm site permissions feature to allow internal SharePoint applications to access websites across farms.











SharePoint Saturday UTAH 2015

Register now!

Registration is still open. See our SPSEvents site for registration, session, and speaker information.


You can’t have SPS without #ShareSki, especially here in Utah! ShareSki is the day before SharePoint Saturday (Friday, Feb 27) on The Greatest Snow on Earth® at Snowbird! Meet at the Gadzoom lift between 9:00 and 9:45. We’ll be taking runs off this lift–returning to it–until 9:45, at which time we can’t guarantee a meetup. If you miss us at Gadzoom or loose us, we’ll have lunch in the Creekside Cafe and Grill at 12:00. Please arrive no later than 12:10 so we can get everyone through checkout in one shot. Go to to purchase your tickets online for $80 (save 16%).


#SharePint is the après-event social of SharePoint Saturday. This gathering is primo for networking and socializing with fellow SharePoint connoisseurs. SharePint will be held at Red Rock Brewing Co., 254 South 200 West, Salt Lake City, starting approximately 6:30.


Special thanks to our sponsors for making this event possible!






Ivan Sanders
SharePoint MVP / MCT

clip_image001 clip_image002 clip_image003 clip_image004 clip_image005

Technorati Tags: SharePoint Saturday UTAH,Business Intelligence,Event

RSA Web Agent 7.1.3 SharePoint WFEs Authentication with Multiple IP Addresses



If you are unable to authenticate the after installation and configuration of the RSA WebAgent, you have downloaded the agent from EMC,  followed the installation instructions.

Configuration and Errors

  1. You have created and copied the sdconf.rec file to %windir%/system32 and to the C:\Program files\RSA Security\RSAWebAgent
  2. When attempting to authenticate you receive “100:Access denied. The RSA ACE/Server rejected the Passcode. Please try again.”
  3. The application Event viewer  there is an Event ID: 1012, Source: ACEClIENT “Multihomed host detected: Primary IP assumed” and this is not the IP Address you are using for your Extended Web App.

The secureid file will not be created and you will not be able to authenticate



RSA Rulesimage

Whenever there are multiple IP Addresses (Multi homed Servers) on a Web Server and the Default Address  is not the primary Addresses used for RSA Authentication . The RSA Agent will NOT create the SecureID file on first authentication and the request will timeout…

  1. If the SharePoint server is configured as the WFE, and you are installing the RSA WebAgent to secure external access, ensure the Local System account has read/write access for the following registry key: HKLM\Software\SDTI\ACECLIENT. This ensures that SharePoint WFE is able to write the secret to the registry.
  2. If the SharePoint WFE  has multiple IP Addresses, you will need to explicitly configure the network adapter address through which SharePoint WFE connects to the RSA Authentication Manager for authentication or authentication will fail. To do this, create a new String Value PrimaryInterfaceIP in the following registry key: HKEY_LOCAL_MACHINE\SOFTWARE\SDTI\AceClient\.
  3. Double Click on  HKEY_LOCAL_MACHINE\SOFTWARE\SDTI\AceClient\PrimaryInterfaceIP 
  4. Add the IP Address as the value data.  The value specified must match that set in the agent host record.


Don’t forget SharePoint Saturday in Utah next Saturday


SharePoint administrators, end users, architects, developers, and other professionals that work with Microsoft SharePoint Technologies will meet for:

SharePoint Saturday Utah on February 28th 2015 at the University of Utah David Eccles School of Business located at 1655 Campus Center Dr. Salt Lake City, UT 84112.







Ivan Sanders
SharePoint MVP / MCT


clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010

Metalogix Content Matrix PowerShell Copy Jobs “Failed to Find the main assembly”

If you have upgraded from a previous version of Metalogic Content Matrix SharePoint edition or have multiple Content Matrix editions (SharePoint, Fileshare, Blog) deployed you may receive the error “Failed to find the main application assembly” when attempting to run any of your PowerShell Copy Job Scripts. If you are not running the Metalogix copy jobs in PowerShell you will not be affected by this issue.



The resolution that worked for me was to uninstall Metalogix Content Matrix Consoles, Content Organizer and the Content Matrix WSPs. Open a command prompt in admin mode and run Gacutil /lr > E:\Apps\gacutil.txt to pipe the contents of the GAC to a txt file to review. In one environment I found two assemblies were not being removed Metalogix.System.Commands.dll and Metalogix.SharePoint.Adapters.StoragePoint.dll. The setup uses Installutil and was unable uninstall the two assemblies listed previously.

From the open command prompt run the followingimage

  • gacutil /u Metalogix.System.Commands.dll
  • gacutil /u Metalogix.SharePoint.Adapters.StoragePoint.dll

substitute any assemblies you found for the ones I used as necessary


Download gacutil as part of the Microsoft Windows SDK for Windows 7 I spoke with Bill Wilcock the Western Regional Support Manager for Metalogix and “Metalogix has determined it is definitely the GAC assemblies and the issue should be resolved in the next hotfix release coming out in a week or two.” 

As I mentioned above, If you are not running the Metalogix copy jobs in PowerShell you will not be affected by this issue. But if your not running the copy jobs in PowerShell you should be; the jobs run at least 2x faster and you can set up a schedule in Task Scheduler to run your incremental jobs daily. This means that when its time to cut over,its very anticlimactic as the site admins, department admins, and end users have verified their content has been successfully migrated, they have time to get used to the new look and feel, and started using the new features prior to Go Live.






clip_image001[4] clip_image002[4] clip_image003[4] clip_image004[4] clip_image005[4] clip_image006


See you in Helsinki March 14th for SharePoint Saturday

SharePoint Saturday San Diego 2014

Don’t miss the upcoming SharePoint Saturday – San Diego on November 15th!


This is a FREE one-day event hosted by the San Diego SharePoint User Group and will feature sessions for end-users, business users, IT professionals and developers. There will also be a track dedicated to Office 365! 

Who Should Attend

SharePoint administrators, end users, architects, developers, and other professionals that work with Microsoft SharePoint Technologies

Where will the event be held

imageUCSD Extension located at

6256 Greenwich Drive, San Diego, CA.




Who will be presenting

This event has confirmed many other nationally recognized SharePoint speakers and Microsoft SharePoint MVPs! Check out the Speakers page on If you are looking to enhance your knowledge of any aspect of SharePoint and/or network with other SharePoint professionals, we strongly encourage you to attend this community event.  image

Why you should attend

Beyond the knowledge and networking, this event will be a blast. There will be a large prize raffle and of course, a ‘SharePint’ social event in the evening. We hope to see you there! Please visit the SharePoint Saturday – San Diego site for more information or to review the recently published speaker schedule. For those of you on twitter, please tweet about this event using the #SPSSD hashtag.

Please register right away! See you there! Register Here!

Who are the Sponsors




Ivan Sanders

clip_image001 clip_image002 clip_image003 clip_image004 clip_image005 clip_image006

2014 Microsoft MVP Award!

Microsoft MVP Banner

Its official, I just received the notification included is an excerpt:

Dear Ivan Sanders,

Congratulations! We are pleased to present you with the 2014 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in SharePoint Server technical communities during the past year.

The Microsoft MVP Award provides us the unique opportunity to celebrate and honor your significant contributions and say “Thank you for your technical leadership.”

Mike Hickman
Community Engagement

Wow another year, this has been the most incredible award I have ever been privileged to receive. I have met so many awesome people. It was a little surreal at first as I was getting to hang with all of my heroes

Thank you for recognizing my community contributions for the 5th year in a row…





clip_image001 clip_image002 clip_image003 clip_image004 clip_image005 clip_image006

SharePoint 2013 Migrations, Are you having fun yet??

Wow what an incredible couple years SharePoint 2013 is still rockin on premise and online

Time Consuming Steps

However, there were two time consuming steps that didn’t have anything to do with the mechanics of the migration or the technology like moving WebParts, Pages, Items, Documents and creating Site Collections from Sites in Additional Content DBs.

  1. 1.The conversion of the Binary File Format documents to the OpenXML File Format.
  2. 2.Teaching folks why managed metadata is important and the creation of a Global Taxonomy, that includes Navigation

Luckily, there were two sources of information that made this easier but still not painless Waldeks Post – Building Global Navigation in SharePoint 2013 (it works) and the WAND Library. Unfortunately, though I have access to the Library the client did not choose to purchase the subscription so we didn’t get to take advantage of the huge library of terms.

WAND has started offering its entire catalog of taxonomies from the cloud, where you have the ability to subscribe monthly and download the parts that your Client needs to either start their taxonomy or fill out their taxonomy.  I have just been through a relatively easy migration 8 Content Dbs and a small 1TB of Content.

Missing Tools for In-Flight Conversion of Site Columns

The largest notable part missing, though metalogix will help you modify Multi-Choice Site Columns to Managed Metadata Site Columns In-Flight, there are NOT ANY migration products that will convert your binary File Format documents to the OpenXML File Format.

The Microsoft tools like Office Migration Planner will not work with a mapped drive using WebDav, but you can still use PowerShell though we found it was actually better to use a staging Farm, Convert all of your Documents using Word Automation Service. then perform a final migration where we modify the columns In-Flight to take advantage of the managed Metadata Site Columns.

This is important, if you want to take advantage of changing the Multi-Choice Site Columns to managed Metadata Site Columns In-Flight. Because if you have not converted all of your RTFs, HTMs, DOCs to DOCX then you will lose the metadata associated with these documents.

I’m not sure why metavis, sharegate, metalogix, tsunami or others do not build document conversion into their products since we need to be moving off the Binary format for many reasons and embracing the OpenXML Format




clip_image002 clip_image004 clip_image006 clip_image007 clip_image009 clip_image010

SharePoint 2013 NOTICE: Microsoft Deactivated SP1 Download

UPDATE: 04-22-2014 Reference: Stefan Goßner

The updated version of Service Pack 1 has been released today!

Refer to the information below to acquire the updated Service Pack for your product:

NOTE The KB articles for the re-released Service Pack is different from the recalled Service Pack.

  • KB 2880551 – SharePoint Foundation 2013 SP1
  • KB 2880552 – SharePoint Server 2013 SP1
  • KB 2880553 – Project Server 2013 SP1
  • KB 2880554 – SharePoint Server Language Pack
  • KB 2880555 – SharePoint Foundation Language Pack
  • KB 2880558 – Office Web Apps Server 2013 SP1

Download links for updated SP1:

Customers with Service Pack 1 Deployed

For customers who have previously deployed Service Pack 1, download the updated Service Pack 1 and install over the existing Service Pack 1 running PSConfig or PSConfigUI immediately following.

Customers without Service Pack 1

For customers without Service Pack 1 deployed, download the updated Service Pack 1 package and deploy as per the KB documentation.


There is no update to the integrated ISO ("slipstream") from MSDN, VLSC and MPN as it was not affected by the issue.

Reference: see official announcement in Bill Baers blog post.


“Notice: We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.”


“Notice:We have recently uncovered an issue with this Service Pack 1 package that may prevent customers who have Service Pack 1 from deploying future public or cumulative updates. As a precautionary measure, we have deactivated the download page until a new package is published.

A known issue in SharePoint Foundation 2013 SP1 can affect the functionality of the Search WebPart. We encourage you to limit production installations of SharePoint Foundation 2013 SP1 until a fix is available. SharePoint Server 2013 is not affected by this issue.”

I would like to thank Andy Williams the Nikon TAM (Microsoft Technical Account Manager), for bringing this to our attention Thursday. Unfortunately, we are affected since we have deployed SP1 to All DEV and PRD Servers. The only good news (I guess) is that our topology consists of Standalone farms for both WAC and WFM.

You may want to also check out Todd’s post as he states that Bill Baer has said that the ISO downloaded from MSDN does not have this issue.




Technorati Tags: ,

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008

Stay Competive with Business Intelligence in SharePoint 2013 & O’Reilly

book cover

Stay Competitive

O’Reilly Media spreads the knowledge of innovators through its books, online services, magazines, research, and conferences. Get the information you need from the experts you trust; visit to purchase this book.

Business Intelligence in Microsoft SharePoint 2013

Get 40% off of the print book and 50% off of the ebook version of this book by entering discount code AUTHD.

By Norman P. Warren, Mariano Teixeira Neto, Stacia Misner, Ivan Sanders, Scott A. Helmers

May 2013, ISBN 978-0-7356-7543-8

406 pages, $34.99


© 2014 O’Reilly Media, Inc. O’Reilly logo is a registered trademark of O’Reilly Media

clip_image001 clip_image002 clip_image003 clip_image004 clip_image006 clip_image008


wordpress stat