SharePoint

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

Brunei Cloud Users Group Monthly Gathering – October 2016

Posted on Updated on

I’m really happy to announce that I will be speaking at the Brunei Cloud Users Group in Brunei, October 29 2016.

More Information
http://www.sharepointbrunei.net/
praneeth@sptricks.com 

October_Session_2016

Brunei Cloud Users Group Monthly Gathering – October 2015

Posted on Updated on

I’m really happy to announce that i will be speaking at the Brunei Cloud Users Group in Brunei, October 31 2015. http://www.sharepointbrunei.net/

BCUGNewOCT2015

SharePoint Brunei User Group Monthly Gathering – March 2015

Posted on

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

SPBUG_Mar2015

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

Hide SharePoint “RibbonRow” and “SuiteBar” From Anonymous Users

Posted on Updated on

For public facing SharePoint sites most of the time peoples don’t want to show SharePoint “Suitebar” and “RibbonRow” for Antonymous Users

1

So here how you can hide SharePoint 2013 “suiteBar” for anonymous users.

  1. Open the master page (default Master and the Home Page Master) using SharePoint Designer. Before edit your master page take a backup copy Smile

image 

2. Select your master page -> right click –>Click on  “check out”

image

image

3. Select the master page again -> right click –> Click on “edit file in advanced mode”

image

4. Find the <div id=”suiteBar” class=”ms-dialogHidden noindex”> code block

image

5. Now change <div id=”suiteBar” class=”ms-dialogHidden noindex”>  to <div id=”suiteBar” class=”ms-dialogHidden noindex” style=”display:none”>

image 

 

This will hide the “suitbar” for all users including login users.but we need to enable suite bar for login users.to do that insert below script block right after the above </div> tag

6.Right click on <div id=”suiteBar” class=”ms-dialogHidden noindex”>  to <div id=”suiteBar” class=”ms-dialogHidden noindex” style=”display:none”> code block and click on “Select Tag”

image 

Suitebar_New

7. insert below script block right after the selected section

<!– My Custom Code –>

<SharePoint:SPSecurityTrimmedControl ID=”HideSuiteBar” runat=”server” PermissionsString=”ManageWeb”>

<script type=”text/jscript”>

document.getElementById(“suiteBar”).style.display = “block”;

</script>

</SharePoint:SPSecurityTrimmedControl>

<!– –>

Hide_SuiteBar_New

 

This will hide SharePoint “SuiteBar” for Anonymous users.

SNAGHTML2c8c40e4

Now we have to hide SharePoint “Ribbon Row”

8.Go to your master page. find  <div id=”s4-ribbonrow” style=”height: 35px; display: inherit !important;”> code block.

image

9. Change <div id=”s4-ribbonrow”> to <div id=”s4-ribbonrow” style=” display:none”>

image

10. Right click on <div id=”s4-ribbonrow” style=” display:none”> code block -> click on “Select Tag”

image 

image

11. Insert below script block right after the above selected </div> tag. (at the end of the Selected Tag)

<!– My Custom Code –>

<SharePoint:SPSecurityTrimmedControl ID=”HideRibbonRow” runat=”server” PermissionsString=”ManageWeb”>

<script type=”text/javascript”>

document.getElementById(“s4-ribbonrow”).style.display = “block”;

</script>

</SharePoint:SPSecurityTrimmedControl>

<!– –>

Hide_S4_Ribbon_New

 

12. After Insert above code block .your page will look like below screenshot.

S4_Ribbon_New

 

13. “Save” your changes and “Check In” the “Master Page”.

14. This is the final output / View for “anonymous” users.

SNAGHTML3e1597c

Note :

You have to “DeactivateMinimal Download Strategy” feature from “Manage Site Features” to take effect all these changes.

Site_Features

Minimal Download Strategy

You can use below url to login to you site.because now you can’t see “Sign in” Link on your pages. 🙂

http://SiteUrl/_windows/default.aspx

Happy Coding  Smile

SharePoint Brunei User Group

Posted on

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

SPB14_New