SharePoint 2013

SharePoint 2013 Excel Service 401 Error

Posted on Updated on

Recently when I’m working with SharePoint Excel services i received below error message.

“Before Opening Book ObjectSystem.Net.SystemNetworkCredentialSystem.Net.WebException: The request failed with HTTP status 401: Unauthorized. at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) at ExcelService.OpenWorkbook(String workbookPath, String uiCultureName, String dataCultureName, Status[]& status)”

to get rid of this error you have to disable “Loopback Check” from front end servers and app servers. you can follow these steps to disable Loopback Check.

Method 1: Specify host names (Preferred method if NTLM authentication is desired)

  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
  3. Right-click MSV1_0, point to New, and then click Multi-String Value.
  4. Type BackConnectionHostNames, and then press ENTER.
  5. Right-click BackConnectionHostNames, and then click Modify.
  6. In the Value data box, type the host name or the host names for the sites, and then click OK.
  7. Quit Registry Editor, and then restart the IISAdmin service.

Method 2: Disable the loopback check (less-recommended method)

  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Quit Registry Editor, and then restart your computer.

 

Happy Coding Smile

Advertisements

SharePoint Brunei User Group Monthly Gathering – October 2014

Posted on Updated on

I’m really happy to announce that i will be speaking at the SharePoint Brunei User Group in Brunei, October 30 2014. http://www.sharepointbrunei.net/

SPB2014OCT

SharePoint 2013 officially Not Supported on Windows 2012 R2 Until SharePoint 2013 SP1 Release.

Posted on Updated on

According to KB 2891274 SharePoint 2013 not supported on Windows 2012 R2 until SP1.You can refer KB 2891274 article for more details.

SharePoint 2013 VM Setup Guide

Posted on Updated on

Use below link to download VM Setup Guide PDF.

SharePoint 2013 VM Setup Guide