Archive for March, 2017

How-To connect Content DB to a SharePoint
Web application
How to restore SharePoint to another farm

The scenario we will use is that we have a web application and we need to attach another Database to it

First copy the database the two files of the content

MDF and LDF files of the content

Copy them to the new farm

In addition, it will be better to disable the web application server

Then right click the databases and right click attach

Then add the MDF file

Then it will be attached with the following name




Read Full Post »

SharePoint Application Proxy Group

Proxy group

is the relationship between web application and the service application connection (Proxy) or connection for a service application

It enables the web application to associate with just the application services needed

EX: my site web application doesn’t need to be associated with all service applications

By default, there is only one Application Proxy Group

Go to central admin


Application Management

Manage web application

Then service connection  



To create new application Proxy Group

New-SPServiceApplicationProxyGroup -Name “new name of your proxy group”

In my case I will create one for the Project server only

New-SPServiceApplicationProxyGroup –Name MSproj_Group

Before command

After command

Now assign service application connection (Proxy) to the Proxy group

Use the following command to get list of Proxies

You need the ID of the required servie

Get-SPServiceApplicationProxy | FT -AutoSize -Property ID, DIs*

Add-SPServiceApplicationProxyGroupMember <Proxygroupname> -Member <ID>

Alternatively, you can run the following command to get list of all services with project name

Get-SPServiceApplicationProxy | where { $_.Name -like “*projec*” }


Now its connected



I will assing another proxy the Usage and health data collection Proxy


Now it is connected

Read Full Post »

Creating Project server on SharePoint 2016

Enable the license

After enabling the server license

Enable-ProjectServerLicense -Key

create service and service proxy connection

Project Server Service Application

Create the service application and start the service

Make sure the proxy connection has been created if not review your topology


Read Full Post »

What is the Sarbanes-Oxley Act and how does AD auditing help with compliance?

The Sarbanes-Oxley Act of 2002, is one of the most consequential set of mandates involving business ethics, and applies to all publicly traded companies, including subsidiaries of foreign companies, in the US.


Read Full Post »

OneDrive for Business retention and deletion

Their OneDrive for Business will be preserved for 30 days. You’re the temporary owner of all documents saved to their OneDrive for Business.


When a OneDrive for Business site collection is scheduled for deletion, the default action is to transfer ownership of the site to the manager of the original work account or school account that is being deleted. For this to occur, the user profile Manager Property must be set for the original owner of the OneDrive for Business site. For more go to OneDrive retention

For this to occur, the user profile Manager Property and Access Delegation need to be set for the deleted user before deleting it. To do that, as a global admin or SharePoint admin, please follow the steps below: 
1. Go to the SharePoint admin center
2. Click User profiles > People > Manage User Profiles > Find the user account to deleted > Edit my profile > Manager > type the manager account into the box > Save and Close

Go to central admin

Then Edit my profile


Read Full Post »

Azure AD Connect sync: Prevent accidental deletes

This topic describes the prevent accidental deletes (preventing accidental deletions) feature in Azure AD Connect.

f this was unexpected, then investigate and take corrective actions. To see which objects are about to be deleted, do the following:

  1. Start Synchronization Service from the Start Menu.
  2. Go to Connectors.
  3. Select the Connector with type Azure Active Directory.
  4. Under Actions to the right, select Search Connector Space.
  5. In the pop-up under Scope, select Disconnected Since and pick a time in the past. Click Search. This page provides a view of all objects about to be deleted. By clicking each item, you can get additional information about the object. You can also click Column Setting to add additional attributes to be visible in the grid.

    The following command:

    First run the following command just to make sure

Get-ADSyncExportDeletionThreshold | FT

Then disable it



Read Full Post »

Project server installation

Project Server 2016 runs as a service application under SharePoint Server 2016. It is included as part of the SharePoint Server 2016 Enterprise installation, though it is licensed separately

Project Server 2016 requires a license in order to operate, and you must enable Project Server 2016 by using your license key before you can create a Project Web App site.

(If you are not sure if Project Server 2016 has already been enabled, use the Get-ProjectServerLicense cmdlet to check.)

To activate Project Server 2016

First make sure that it’s not enabled

Open the SharePoint admin shell

Make sure to run as admin


Read Full Post »

Older Posts »

%d bloggers like this: