Melick's Blog

The XSS Auditor refused to execute a script in http://default.aspx because its source code was found within the request. The auditor was enabled as the server sent neither an 'X-XSS-Protection' nor 'Content-Security-Policy' header in SharePoint 2013 Recent google chrome update may breaks the sharepoint layout pages and other custom development pages due to XSS Auditor. I have added the HTTP Response Header  to the SharePoint Web Front End Servers  and then it worked fine.    

There are many scenarios that you need to list down all your existing Reporting subscription in the SharePoint. Sometimes , you might find your reporting server subscription is not showing the in the manage subscription menu. There is a reason for it. Currently subscriptions  are saved based on URL (Alternative access URL) and User. So if your farm has different AAMs, even though you are a same user , it will not show under your subscriptions. So how you can get it. There is a no direct function to get this unless you are using SSRS API to query the data. but you can find these entries by simply querying SSRS SharePoint database.   SELECT   *    FROM [ReportingService_ServiceApplication_DB].[dbo].[Subscriptions] with(nolock) You can find below details [SubscriptionID] ,[OwnerID] ,[Report_OID] ,[Locale] ,[InactiveFlags] ,[ExtensionSettings] ,[ModifiedByID] ,[ModifiedDate] ,[Description] ,[LastStatus] ,[EventType] ,[MatchData] ,[LastRunTime] ,[P...

How to copy you production SharePoint  database to development environment. I had my production environment as SharePoint 2013 SQL Server 2012 and I want to move the instance to another environment , which is freshly installed and different environment and different KBs Share Point 2013 SQL Server 2016 How to migrate SharePoint 2013 , SQL Server 2012 Content Database to SharePoint 2013 SQL Server 2016. Method 1. This is a general method, which is used for upgrading your content database. 1 . Get the back up of the current Content Database 2. Copy SQL backup to new environment 3. Restore the SQL Back Up in to the new environment 4. Go to the Security Login section and grant permission to content database for existing SharePoint Users.   5. You need to select the User mapping and DBO for the content database. 6 Then, execute below PS in SharePoint PowerShell. Make sure you executed as Run as Administrator 7 Firstly, You need to Update the content database. 8. then, mount the usi...

I have come across this error while I'm generating SharePoint Business Object using Entity Framework. Error Microsoft.Data.Entity.Design.VersioningFacade.ReverseEngineerDb.SchemaDiscovery.EntityStoreSchemaGeneratorDatabaseSchemaLoader.CreateFilteredCommand(String sql, String orderByClause, EntityStoreSchemaFilterObjectTypes queryTypes, List`1 filters, String[] filterAliases) This happed when I change the Framework for match new Visual Studio environment. Solution. There were lots of suggestions, however , below method worked for me. First, we need to open the visual studio command prompt. because, gacutil will not work in normal command prompt , unless you specified the path. then you can execute the below gacutil command to remove the wrong EntityFramework version. gacutil /u EntityFramework

Issue Could not establish trust relationship for the SSL/TLS secure channel with authority Environment: SharePoint 2013 Farm with multiple nodes connected to connected to load balancer have a Service Oriented architecture to connect other services from SharePoint app servers SharePoint Nodes are connected to  other services using services oriented services using endpoint defined   Symptoms :   SharePoint servers are communicate with Remote service using https protocol using   SSL. When I check the validity of the remote certificate from the browser It depicts it is valid. Resolution I took while me to figure this out. It is true it is about the certificate but it is not the  end certificate. certificate chain is broken in the Intermediate level. You can find this easily by checking details from Certificate. Then navigate to Certification Path You should see these Root and Intermediate as verified. If they are not valid or expired, you will see a wa...

This article is a to ensure how to create a simple SharePoint 2016 Page layout without using Share Point designer Design Manager Before doing anything you need to create the base of the layout. Following placeholders are minimal and commonly used in any template. PlaceHolderAdditionalPageHead PlaceHolderPageTitle PlaceHolderMain Place Holders PlaceHolderAdditionalPageHead This place holder is used to defined additional CSS and other scripts and inline CSS if you have any. We will be using this to register a CSS and register a different CSS for the SharePoint Edit Mode < asp:Content ContentPlaceHolderId = "PlaceHolderAdditionalPageHead" runat = "server" > <!—Your code goes here--> </ asp:Content > PlaceHolderPageTitle This place holder will be mainly for the page title. < asp:Content ContentPlaceHolderId = "PlaceHolderPageTitle" runat = "server" > <!—Your code goes here--> </ asp:Content > PlaceHolderMain Th...

Issue This error appeared when I'm configuring the SharePoint 2013  farm Pre Requisites using the installer. Use AutoSPInstaller and it will end with below error 2019-01-22 09:48:02 - Return code (2) 2019-01-22 09:48:02 - It is recommended that you keep your Windows operating system up to date on http://windowsupdate.microsoft.com When you try SharePoint prerequisites installer (prerequisiteinstaller.exe) it ends with below error. Application Server Role, Web Server (IIS) Role: configuration error How to solve this issue There are numerous reasons where you will encounter this issue. Resolution 1 Try to execute the installer using Admin Account and you should be a local admin on your sever. Resolution 2 Install the .Net components manually using server manager. Add Roles and Features and then Skip until you  reach Features , And install .NET 3.5 and 4.5 as described. You might need to insert Source Path for installing 3.5 Framework.  Resolution 3 Sometimes installer cou...

Issue AppFabric installation failed because installer MSI returned with error code : 1603 Symptoms Installing SharePoint using  Off Line method using Auto SP Installer. Installing SQL server before in the same server , this is happening when you set up a Test server where you install everything in the same server. Install or manual installing App Fabric with out going thorough prerequisites installer. Manually updating existing App fabric installation with all features.   Resolution There could be many reason behind this problem. But most common problems due to manual installation and having incorrect system variable for the PowerShell path. How to Resolve Method One Just uninstall the existing installation from the control panel and re-run the SharePoint prerequisites installer or Auto SP Installer Method Two Change the System Variable to correct value if it is wrong. for this go to the  PC Properties then Advanced System Properties and Environment Variables Then check ...

My first article I have explained about a creation of Basic Share Point  Page Layout. http://melick-rajee.blogspot.com/2018/07/sharepoint-2016-create-custom-layout.html By referring above article you can create a simple Page Layout as below. <%@ Page Language="C#" Inherits="Microsoft.SharePoint.Publishing.PublishingLayoutPage, Microsoft.SharePoint.Publishing,Version=15.0.0.0,Culture=neutral,PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="SharePointWebControls" Namespace="Microsoft.SharePoint.WebControls" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="WebPartPages" Namespace="Microsoft.SharePoint.WebPartPages" Assembly="Microsoft.SharePoint, Version=15.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %> <%@ Register TagPrefix="PublishingWebControls" Namespace="Microsof...

This article is a to ensure how to create a simple SharePoint 2016 Page layout without using Share Point designer Design Manager Before doing anything you need to create the base of the layout. Following placeholders are minimal and commonly used in any template. PlaceHolderAdditionalPageHead PlaceHolderPageTitle PlaceHolderMain Place Holders PlaceHolderAdditionalPageHead This place holder is used to defined additional CSS and other scripts and inline CSS if you have any. We will be using this to register a CSS and register a different CSS for the SharePoint Edit Mode < asp:Content ContentPlaceHolderId = "PlaceHolderAdditionalPageHead" runat = "server" > <!—Your code goes here--> </ asp:Content > PlaceHolderPageTitle This place holder will be mainly for the page title. < asp:Content ContentPlaceHolderId = "PlaceHolderPageTitle" runat = "server" > <!—Your code goes here--> </ asp:Content > PlaceHolderMain T...

Microsoft Sway Microsoft Sway is a great online Presentation and Online Creativity Stack. Why we need Sway Assume that you are about to so a cooperate presentation for your colleagues. what are the options you have Firstly,You can create a PowerPoint presentation which you need a PowerPoint to run and if you want to share you need end users have PowerPoint client for view the deck. Secondly, You can create a simple web pages and share it with users where it can be access from all devices if it is responsive. Microsoft Sway address the second point. How to Access the Sway There are many ways that you can do this. Since I'm trying  use Sway with SharePoint Online; I will describe using SharePoint Online. First Login to the SharePoint Online Office 365 Login | Microsoft Office There You can go to all Apps   Then you can find the Sway as a App in the Menu   Click on the Sway and go the Sway web site. Here you can find standard available temples or you can start from the stre...