SP Tricks

Time 2021-06-17 23:41:54

Web Name: SP Tricks

WebSite: http://hpksanje.wordpress.com

ID:183780

Keywords:

SP,Tricks,

Description:

SharePoint 2013 Excel Service 401Error Posted on December 14, 2016 Updated on December 14, 2016 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) Click Start, click Run, type regedit, and then click OK.In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0Right-click MSV1_0, point to New, and then click Multi-String Value.Type BackConnectionHostNames, and then press ENTER.Right-click BackConnectionHostNames, and then click Modify.In the Value data box, type the host name or the host names for the sites, and then click OK.Quit Registry Editor, and then restart the IISAdmin service.Method 2: Disable the loopback check (less-recommended method) Click Start, click Run, type regedit, and then click OK.In Registry Editor, locate and then click the following registry key:HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\LsaRight-click Lsa, point to New, and then click DWORD Value.Type DisableLoopbackCheck, and then press ENTER.Right-click DisableLoopbackCheck, and then click Modify.In the Value data box, type 1, and then click OK.Quit Registry Editor, and then restart your computer.Happy Coding Hide SharePoint RibbonRow and SuiteBar From AnonymousUsers Posted on September 23, 2014 Updated on November 2, 2014 For public facing SharePoint sites most of the time peoples don’t want to show SharePoint “Suitebar” and “RibbonRow” for Antonymous UsersSo here how you can hide SharePoint 2013 “suiteBar” for anonymous users.Open the master page (default Master and the Home Page Master) using SharePoint Designer. Before edit your master page take a backup copy 2. Select your master page - right click – Click on “check out”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 ! This will hide SharePoint SuiteBar for Anonymous users.Now we have to hide SharePoint Ribbon Row 8.Go to your master page. find div id= s4-ribbonrow >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 ! 12. After Insert above code block .your page will look like below screenshot. 13. “Save” your changes and “Check In” the “Master Page”.14. This is the final output / View for “anonymous” users.Note :You have to “Deactivate”Minimal Download Strategy” feature from “Manage Site Features” to take effect all these changes. You can use below url to login to you site.because now you can t see “Sign in” Link on your pages.

TAGS:SP Tricks 

<<< Thank you for your visit >>>

SharePoint Tricks

Hot Websites