One of new and hidden feature in SharePoint 2013 is that you can specify the maximum upload size per file type 😉
Actually the default maximum upload is 250MB and you can modify it from central administration.
But, you can specify the this size as per file type using power shell cmdlet in MB.
$webApp = Get-SPWebApplication “http://sp2013:2000”
So I told SharePoint to allow uploading AVI files up to 500 MB.
And you can see all available file types in their sizes
You can find the connection string for SharePoint 2013 configuration database in register path, here:
“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\Secure\ConfigDB”
As you know the menu item Sign in as Different User has been removed from SharePoint 2013 UI.
The good news is the functionality still there using the below link:
And you can add it again to the menu using Visual Studio 2012 solution as below:
Create a new SharePoint 2013 solution in Visual Studio 2012
Add new Module to the project
Remove the Sample.txt file from added module
Copy and paste the following XML in the element file
<?xml version="1.0" encoding="utf-8"?>
Title="Sign in as Different User" >
<UrlAction Url="~site/_layouts/AccessDenied.aspx?loginasanotheruser=true" />
The result is:
In some organization you may meet requirements to remove the SharePoint version from HTTP response header for security reasons.
This is a snapshot of Fiddler response header from SharePoint 2013
Our goal is remove the MicrosoftSharePointTeamServices: 220.127.116.1120
To do this,
Go to “C:\inetpub\wwwroot\wss\VirtualDirectories\<your app virtual directory>”
In the web.config file go to system.webserver >> httpProtocol >> customHeaders
Add the following line <remove name=“MicrosoftSharePointTeamServices“/>
Go again to fiddler to see the result
NOTE: this may effect other applications like InfoPath.
When you try to install SharePoint 2013 on Windows Server 2012 you need to install he prerequisites before SharePoint 2013.
You may get this error.
And when you open the log file, you will see the below error
Error when enabling ASP.NET v4.0.30319
Go to Server Manager >> add roles
Select Web Server (IIS)
Pass the Features and Web Server Role (IIS)
You may need to restart the server after above changes
To disable mobile redirection in SharePoint 2013 follow the below steps:
C:\inetpub\wwwroot\wss\VirtualDirectories\<your web app folder>\App_Browsers
Search for “isMobileDevice” across all file and change its value to “false” and save the file
In SharePoint 2013, when you trying to open an excel sheet with external data connection, you may see the below warning:
“This workbook contains one or more queries that refresh external data. A malicious user can design a query to access confidential information and distribute it to other users or perform other harmful actions. If you trust the source of this workbook, click Yes to enable queries to external data in this workbook. If you are not sure, click No so that changes are not applied to your workbook. Do you want to enable queries to external data in this workbook?”
Screen shot of the warning
To remove this waning, follow the below steps:
Go to Central Administration >> Manage service applications >>
Go to your excel service application and click on it to enter the service application administration page.
Click on “Trusted File Locations”
Open your trusted location and clear the below Check box “Refresh warning enabled”
Click OK and try 🙂