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.    

SqlConnection SC = new SqlConnection( "Place your connection string here" ); string sqltxt = "" ; string ipath = "C:\Backup.Bak" ; sqltxt = @"BACKUP DATABASE SampleDB TO DISK = ' " + ipath + "' WITH INIT " ;     SqlCommand sqlCm = new SqlCommand(sqltxt, SC); SC.Open(); sqlCm.ExecuteNonQuery(); SC.Close();

Open a new Visual Studio windows application project (c#) Right click the project and goto AddNew item . and it will popup the following dialog. select the Linq to SQL Classes and give a neme add click add. then double click the added class in your solution explorer. Then it will load following type of screen. In the Data connection (Assumme you already created a SQL Server Database and also a table nemed "Table1"), Drag and drop the table to the window. Then it will ask for connection string saving dialog. For the moment keep it NO. Now we will see how to use LINQ to do Insert , Update , Delete. Coding is describing below. ( sample is the name given by me to the LinqtoSQL class). private void cmdAdd_Click( object sender, EventArgs e) { sampleDataContext Dt = new sampleDataContext(); Table1 T = new Table1(); T.Address = "Address 1" ; T.Name = "a" ;   Dt.Table1s.InsertOnSubmit(T); Dt.SubmitChanges();

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] ,[Parameters] ,[DataSettings]

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 using the co

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

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 warning sign near to the certificate