Connect to SQL Server with Different Port

For security reasons, it is recommended to change the default SQL Server default port which is 1433 to a new port.

To connect to SQL Server with different port rather than default port, use comma after server name: DevSQL,5511



Release Locked (checked out) Document in SharePoint

As a feature in SharePoint, you can check out any document item.

Sometime, the user who check out the document library is not available and the admin need to release (undo check-out) the document library.

We can use the following power shell script (Change the bold values)


$web=Get-SPWeb $WebSiteURL
$user = $web.AllUsers.GetByID($userId)

$impSite= New-Object Microsoft.SharePoint.SPSite($web.Url, $user.UserToken)
$impWeb = $impSite.OpenWeb()


Change Project Server 2013(EPM) Security Mode

In Project Server 2013 (EPM 2013) there are two security modes:

  • SharePoint Mode (Default)
  • Project Server Mode

In Project Server Mode, there are more customization security groups and other functionality that is distinct from SharePoint groups.

to switch between those modes, user SharePoint 2013 PowerShell console and run the below commands:

  • SharePoint Mode
Set-SPPRojectPermissionMode -Url http://WebApplication/pwa -AdministratorAccount Domain\serviceAccountName -Mode SharePoint
  • Project Server Mode
Set-SPPRojectPermissionMode -Url http://WebApplication/pwa -AdministratorAccount Domain\serviceAccountName -Mode ProjectServer

after using Project server mode, the security will look like below image: