Melick's Blog

AutoSPInstaller Online is one of a great project that facilitate Automated SharePoint installation including Sharepoint 2010, 2013 and 2016. Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm. Reference: https://autospinstaller.com/ Before doing anything we will set up the environment for SharePoint three server Farm. Will name these servers as SPWFE - Share Point Front End Server SPAPP - Share Point App server SPDB - DB server Please find the reference for SharePoint minimum requirement and practices from https://docs.microsoft.com/en-us/SharePoint/install/install-sharepoint-server-2016-across-multiple-servers For the the medium segregation, we have to create below list of service accounts. Service Accounts for Active Directory Service Account name : spadmin Rights : Local Admin All Servers (DB,WFE,APP) SQL DB Rights: SQL DB Creator and Security Admin Rights Domain Privileges: Service ...

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...

This article will be divided to three sections Setting up the Environment and Service Accounts Getting Ready with AutoSPInstaller Online Configuring the XML using Online Editor and Installation Setting up the Environment and Service Accounts AutoSPInstaller Online is one of a great project that facilitate Automated SharePoint installation including Sharepoint 2010, 2013 and 2016. Auto SP Installer provides a powerful way to deploy and configure a single-server development environment to multiple-server SharePoint farm. Reference: https://autospinstaller.com/ Before doing anything we will set up the environment for SharePoint three server Farm. Will name these servers as SPWFE - Share Point Front End Server SPAPP - Share Point App server SPDB - DB server Please find the reference for SharePoint minimum requirement and practices from https://docs.microsoft.com/en-us/SharePoint/install/install-sharepoint-server-2016-across-multiple-servers For the the medium segregation, we have to create...

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

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...

This the final article of Auto SP Installer for SharePoint 2016. Please refer my previous articles if you are interested in SharePoint 2016 Installation using AutoSPInstaller Online Part 1– Setting up the Environment and Service Accounts http://melick-rajee.blogspot.com/2018/09/sharepoint-2016-installation-using.html SharePoint 2016 Installation using AutoSPInstaller Online Part 2– Getting Ready with AutoSPInstaller Online http://melick-rajee.blogspot.com/2018/10/sharepoint-2016-installation-using.html Purpose of this article to user Online Editor to SharePoint Installation configuration. after you have set up everything, as per my previous articles, You need to go to Online Configuration Editor https://autospinstaller.com/FarmConfiguration Then you need to choose Load from my XML and and choose the AutoSPInstallerInput file. Then the below page will be visible. we don't need to edit all the configurations for this scenario. First add the HOST name for the SharePoint Server. Since...