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:

ProjectServerSecurity

References:

 

Advertisements

PlatformNotSupportException When Using VS 2012 With SharePoint 2013

While I writing a small console to insert items in SharePoint 2013 task list, I got the follwoing error:

Microsoft SharePoint is not supported in 32-bit process. Please verify that you are running in a 64-bit executable.

An her the screen shot of the exception:

0

Solution

Right click on the project in Solution Explorer and click on Properties

1

Then go to Build tab and do the following:

  • Platform target >> Any CPU
  • Clear the check box on “Prefer 32-bit

2

Upload files using Windows Explorer instead Not Available – SharePoint 2013

When you try to upload multiple documents to document library in SharePoint 2013 you may notice that the option “Upload files using Windows Explorer instead” to upload multiple document is not available or hidden.

Issue

There is many reasons behind this, one of them is you are opening the document library Internet Explorer 64-bit.

Solution

Just open it in Internet Explorer 32-bit.

Result

 

 

Get Document Path (ServerRelativeUrl) in SharePoint 2013 using REST API

Suppose we have a document in document library in SharePoint 2013 inside sub folders

Ex: /En/Documents/Folder1/Folder2/stats.png

Now, using REST API we need to get the Server Relative Url (ServerRelativeUrl) by the document ID.

Solution

The REST API url will be: http://<server name>/<sub site>/_api/web/lists/getbytitle(‘Documents’)/items(‘<Document ID>’)/File

In my case it will be : http:// <server name>/En/_api/web/lists/getbytitle(‘Documents’)/items(‘5‘)/File

Result

Hiding SYNC from SharePoint 2013

If you need to remove the SYNC option in SharePoint 2013

Go to Settings under Site Collection level and go to Search section

http://<web_application>/_layouts/15/settings.aspx

Under “Offline Client Availability” choose NO

SharePoint 2013 Configuration Database Connection String

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”