Office Integration with SharePoint

Updates

Office 2007 supported extended until April 2017

Obsolete Products
https://support.microsoft.com/en-us/gp/lifeobsoleteproducts
End of Life Products
https://support.microsoft.com/en-us/gp/lifeselectoff
Support Lifecycles
https://support.microsoft.com/en-us/lifecycle#gp/lifePolicy

2016

https://www.avepoint.com/blog/avepoint-blog/sharepoint-2016-frequently-asked-questions/

2013

IE 10 or 11 Compatibility Issues (use compatibility mode)
http://blog.fpweb.net/sharepoint-internet-explorer-compatibility-issues-with-video/#.Vqd6RYd4fcs
https://connect.microsoft.com/IE/feedback/details/808799/internet-explorer-11-doesnt-work-well-with-sharepoint-and-infopath-form
http://social.technet.microsoft.com/wiki/contents/articles/26663.issues-with-sharepoint-2013-with-internet-explorer-11.aspx
http://windows.microsoft.com/en-IN/internet-explorer/use-compatibility-view#ie=ie-11-win-7

Can I use Office 2010 with SharePoint 2013?
http://bit.ly/1Uokayc

Cannot open or create word documents in SharePoint 2013 with Office 2010 and Project 2013
http://blogs.technet.com/b/raymond_ris/archive/2013/04/04/cannot-open-or-create-word-documents-in-sharepoint-2013-with-office-2010-and-project-2013.aspx

SharePoint 2013, Cannot Open Documents in Office 2010 or Office 2013
http://serverfault.com/questions/529629/sharepoint-2013-cannot-open-documents-in-office-2010-or-office-2013

Fix problems opening documents in SharePoint libraries
SP 2013 Office 2010
https://support.office.com/en-US/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329FA1-4AD0-47FC-95D8-BB0C5B12A536

Co-Authoring Support
http://technet.microsoft.com/en-us/library/ff718249(v=office.15).aspx

Issues Running Office 2010 and SharePoint 2013

https://support.office.com/en-us/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329fa1-4ad0-47fc-95d8-bb0c5b12a536

http://sharepointmadam.blogspot.com/2014/01/using-office-2010-with-sharepoint-2013.html

https://social.technet.microsoft.com/Forums/sharepoint/en-US/dde334db-88f5-4ea0-b5d7-3e47503e17de/limitations-when-using-sharepoint-2013-together-with-office-2010

https://blogs.technet.microsoft.com/projectsupport/2013/04/04/sharepoint-2013-problems-opening-documents-with-office-2010-if-you-load-project-2013/

2010

Compatability Issues with Sharepoint 2010 and Office 2016
https://social.technet.microsoft.com/Forums/ie/en-US/df4a3830-15e4-4791-8071-d003d2cceacd/cant-edit-word-and-excel-documents-with-office-2016-in-sharepoint-2010?forum=sharepointgeneralprevious

Fix problems opening documents in SharePoint libraries
SP 2010 Office 2013
https://support.office.com/en-US/article/Fix-problems-opening-documents-in-SharePoint-libraries-31329FA1-4AD0-47FC-95D8-BB0C5B12A536

Compatability Issues with Sharepoint 2010 and Office 2013
http://bit.ly/1WMJqzO

Synchronize SharePoint 2010 content with Outlook 2010
http://office.microsoft.com/en-us/sharepoint-foundation-help/synchronize-sharepoint-2010-content-with-outlook-2010-HA101881295.aspx

Client Features for Office 2003 2007 or 2010 (pdf)
http://go.microsoft.com/?linkid=9690494

Microsoft Office 2010 with Different Versions of Microsoft SharePoint
http://mrin17.wordpress.com/2010/04/29/microsoft-office-2010-with-different-versions-of-microsoft-sharepoint/

SharePoint 2010 with Office 2013 Clients (IE 9 – 32 bit)
https://social.technet.microsoft.com/Forums/sharepoint/en-US/9124f4f9-02e4-4997-a54c-da14e8069964/compatability-issues-with-sharepoint-2010-and-office-2013?forum=sharepointgeneral

http://social.technet.microsoft.com/Forums/en-US/fde11a55-4f9a-420d-b2a1-b000a81c6795/compatibility-issue-between-desktop-office-2010-and-sharepoint-2013?forum=sharepointgeneral

http://social.technet.microsoft.com/Forums/en-US/a7bbb703-4bf0-4f2d-b27a-74aa03aa7e6c/ms-office-2013-and-ms-shaarepoint-2010-compatibility?forum=sharepointadminprevious

http://social.technet.microsoft.com/Forums/en-US/c0eb8246-d8b1-4b78-b603-d08f803c3d17/will-infopath-2013-compatible-with-sharepoint-2010?forum=sharepointdevelopmentprevious

http://support.microsoft.com/kb/2755126/en-us

Issues with Office 2013 in SharePoint 2010 Farm

Excel 2013 workbook in a SharePoint Server 2010 farm
http://support.microsoft.com/kb/2755126

Visio 2013 Files in SharePoint 2010
http://blogs.msdn.com/b/chhopkin/archive/2013/02/14/working-with-visio-2013-files-in-sharepoint-2010.aspx

Known Office 2013 Issues - (Use Find - SharePoint)
http://office.microsoft.com/en-us/help/office-2013-known-issues-HA102919019.aspx

Thursday, October 12, 2017

High Availability in SharePoint

As we become more dependent on SharePoint, how do we keep it online always?  SQL must first be online.  Here is more to help.

AlwaysOn

Brents take on Always On
http://brentozar.com/go/alwayson

Detailed steps to configure an AlwaysOn Availability Group for SharePoint
http://technet.microsoft.com/en-us/library/jj715261.aspx

SharePoint 2013 and SQL Server AlwaysOn - High Availability SharePoint
http://blogs.msdn.com/b/sambetts/archive/2013/04/24/sharepoint-2013-and-sql-server-alwayson-high-availability-sharepoint.aspx

SQL 2012 AlwaysOn Availability Groups for SharePoint 2013 - SharePoint Connections Amsterdam 2012
http://www.slideshare.net/michaeltnoel/sql-2012-alwayson-availability-groups-for-sharepoint-2013-sharepoint-connections-amsterdam-2012

SQL Clusters

Many thinks from Brent Ozar … thx brent and kendra

Introduction to SQL Server Clusters (2012)
https://www.brentozar.com/archive/2012/02/introduction-sql-server-clusters/

Why doesn’t SQL Server always share memory well with other applications? Well, not all applications share memory in ways that work well with it! More information is here: http://msdn.microsoft.com/en-us/library/ms177455.aspx

Brent did a great webcast comparing disaster recovery options. He gives an overview of different methods along with pros and cons of each one. Check it out here: https://www.brentozar.com/archive/2011/12/sql-server-high-availability-disaster-recovery-basics-webcast/

Can you explain a little more on your reluctance to cluster a virtualized server?  “Why Your SQL Server Cluster Shouldn’t Be Virtualized” https://www.brentozar.com/archive/2012/09/why-your-sql-server-cluster-shouldnt-be-virtualized/

Excellent three part series on cluster network communication in Server 2008 by Chuck Timon: http://blogs.technet.com/b/askcore/archive/2010/02/12/windows-server-2008-failover-clusters-networking-part-1.aspx

Everything You Know About Clustering is Wrong
https://www.brentozar.com/archive/2012/06/everything-know-about-clustering-wrong/

very tricky to make SSIS highly available. Here’s a blog post explaining the challenges and one workaround here:
http://blogs.technet.com/b/andrew/archive/2008/11/28/high-availability-integration-services-in-sql-server.aspx

Want more info? See “Running multiple instances of SQL Server” here– it’s not specific to clustering but the same info applies: http://msdn.microsoft.com/en-us/library/ms178067.aspx. Note that the article lists three approaches, and I am recommending the second one, which lets you get the most bang for your buck, but I do still recommend setting max memory.

These properties are one of the interesting things about working with clusters. Check out Books Online here: http://msdn.microsoft.com/en-us/library/ms174396.aspx

Microsoft has published some general requirements for failover clustering hardware: http://technet.microsoft.com/en-us/library/jj612869.aspx

First start by checking out our explanations of the different recovery technologies at https://www.brentozar.com/go/fail and there’s resources for each one.

https://www.brentozar.com/sql/sql-server-failover-cluster/

high availability planning worksheet: https://www.brentozar.com/archive/2014/05/new-high-availability-planning-worksheet/

Brent’s video on licensing here: https://www.brentozar.com/archive/2014/09/how-sql-server-licensing-works/

https://www.brentozar.com/archive/2015/06/how-to-set-up-standard-edition-alwayson-availability-groups-in-sql-server-2016/

How to install and fail over your clustered instance
https://technet.microsoft.com/en-us/library/ms189134%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

Resources

https://www.brentozar.com/responder/

Technet
http://technet.microsoft.com/en-us/library/cc748824.aspx

Great SQL Resource
http://dba.stackexchange.com.

Third Party Solutions
http://sharepointgalaxy.blogspot.com/search/label/vendor