How to move SharePoint Manager Plus to a new server

How to move SharePoint Manager Plus to a new server

Points to be noted before moving SharePoint Manager Plus to a new location:

  1. Do not uninstall SharePoint Manager Plus from the current server until the installation on the new server works perfectly.
  1. If the operating system on the new server is Windows Server 2008 or Windows 7, turn off User Account Control since this setting will allow only an administrator to install the product. (Steps: Control Panel → User Accounts → User Accounts → Turn User Account Control Off)
  1. Identify the build number of your current SharePoint Manager Plus installation. To know the build number: Logon to SharePoint Manager Plus → Click on the License link located in the top-right corner.
  1. Click here to check if you are using the latest build of SharePoint Manager Plus. If not, download the service pack and update SharePoint Manager Plus to the latest build.
  1. If you have configured a Microsoft 365 tenant using the Azure Application, you will need the database console password. Please contact support@sharepointmanagerplus.com for the password before moving your SharePoint Manager Plus installation to a new server.

Note: The following steps are applicable only if your SharePoint Manager Plus installation uses pgSQL database.


There are two ways in which migration can be achieved:

Method 1: Moving the existing SharePoint Manager Plus installation from the current location to a new location/server.

Method 2: Downloading and installing SharePoint Manager Plus on the new server and restoring the DB backup taken from the old instance.


1) Moving the existing SharePoint Manager Plus installation from the current location to a new location/server

  

Follow the steps below to migrate the license, product configurations, and all the data:

  1. Stop SharePoint Manager Plus. (Go to services.msc → Stop SharePoint Manager Plus service).
  1. Open a command prompt (Run as administrator). Navigate to <Installation Directory>\ManageEngine\SharePoint Manager Plus\bin and execute stopDB.bat. This will stop the database.
  1. Close the command prompt and copy the entire SharePoint Manager Plus folder to the new server or drive. Make sure you verify the folder size on both servers.
  1. Then open a command prompt (Run as administrator) on the new server and navigate to <installation-directory>\ManageEngine\SharePoint Manager Plus\bin. Execute InstallSPMPAsService.bat to install SharePoint Manager Plus as a service.
  1. Execute initPgsql.bat Stonebraker.
  1. Open <New Location>\ManageEngine\SharePoint Manager Plus\ES\config\elasticsearch.yml. Replace path.data and path.repo values with new location.

Sample code:

path.data :

- <New Location>\ManageEngine\SharePoint Manager Plus\ES\data
path.repo : <New Location>\ManageEngine\SharePoint Manager Plus\ES\repo

  1. Start SharePoint Manager Plus service by navigating to Services.msc → SharePoint Manager Plus Service → Start the service
  1. After moving SharePoint Manager Plus to a new location, follow the steps shown here if you have configured a Microsoft 365 Tenant using the Azure Application.

Note: If you are using MS SQL server as backend DB and if the MS SQL is running in a remote computer, make sure to download and install SQL native client, command line utilities, and ODBC Driver in the new machine in which SharePoint Manager Plus is running.

SQL Server version

Command Line Utilities (cmdlnutils)

Native Client (ncli)

ODBC Driver (odbc)

2008

https://www.microsoft.com/en-in/download/details.aspx?id=44272

https://www.microsoft.com/en-in/download/details.aspx?id=44272

Not required

2012

https://www.microsoft.com/en-in/download/details.aspx?id=43339

https://www.microsoft.com/en-in/download/details.aspx?id=43339

Not required

2014

https://www.microsoft.com/en-US/download/details.aspx?id=53164

Not required

https://www.microsoft.com/en-in/download/details.aspx?id=36434

2016, 2017, and 2019

https://www.microsoft.com/en-us/download/details.aspx?id=56833

Not required

https://www.microsoft.com/en-us/download/details.aspx?id=56833


2) Downloading and installing SharePoint Manager Plus in the new server and restoring the DB backup taken from the old instance  


  1. Stop SharePoint Manager Plus.

    • Steps: Start → All Programs → SharePoint Manager Plus → Stop SharePoint Manager Plus (or),

    • Start → Run → services.msc → Stop ManageEngine SharePoint Manager Plus service.

  1. Navigate to <Installation Directory>\SharePoint Manager Plus\bin and open an elevated Command Prompt (right-click Command Prompt and select Run as administrator).

    1. Run backupDB.bat file to back up the database of your current installation. The backup file can be found inside the folder where SharePoint Manager Plus has been installed (C:\ManageEngine\SharePoint Manager Plus\Backup)(Example: OfflineBackup_20161129235853.ezip).

Note: Make sure that password is configured under Admin → Custom Settings → Database Settings.

3.      Download and install SharePoint Manager Plus on the new server.

4.      In the new server, start the product and verify the build number. Then, stop the product.

5.      Copy the compressed database backup file created in the old server to the following location in the new server: \SharePoint Manager Plus\bin (For example: C:\ManageEngine\SharePoint Manager Plus\bin)

6.      In the new server, navigate to \SharePoint Manager Plus\bin and open an elevated command prompt (right-click Command Prompt and select Run as administrator).

7.       Execute the restoreDB.bat file from the Command Prompt using the compressed database file. For example: restoreDB.bat "C:\ManageEngine\SharePoint Manager Plus\OfflineBackup_20161129235853.ezip" -p

8.      When it prompts for a password, Enter the password you configured under Database Settings.

9.      Copy the archive, archive_index and ES folders present in <Installation Directory>\SharePoint Manager Plus and paste them to <New Installation Directory>\SharePoint Manager Plus.

10. Open <New Location>\ManageEngine\SharePoint Manager Plus\ES\config\elasticsearch.yml. Replace path.data and path.repo values with new location.

Sample code:

path.data :

- <New Location>\ManageEngine\SharePoint Manager Plus\ES\data
path.repo : <New Location>\ManageEngine\SharePoint Manager Plus\ES\repo

11.    Copy the customer-config.xml and database_params.conf files present in <Installation Directory>\SharePoint Manager Plus\conf and paste it to <New Installation Directory>\SharePoint Manager Plus\conf.

12.  Apply the original license file sent to your email from licensing@manageengine.com. Alternatively, you can also copy the license folder present in <Installation Directory>\SharePoint Manager Plus\lib and paste it to <New Installation Directory>\SharePoint Manager Plus\lib.

13.  To start the product, click Start → All Programs → SharePoint Manager Plus → Start SharePoint Manager Plus.


After moving SharePoint Manager Plus to a new location, follow the steps below if you have configured a Microsoft 365 Tenant using Azure Application.  

1.        Navigate to <Product Location>\bin, where <Product location> is the location where SharePoint Manager Plus has been installed.

2.      Open Command Prompt here and run the following command.
connectDB.bat

3.      Once the Database Console opens, run the below command.
Select farm_id, cert_path from AzureAppCredentials;

4.      You can find the former certificate location under cert_path column.

5.      Find the new location of the certificate and copy its path.

Note: If the product is moved from 'C:\Program Files\ManageEngine' to 'D:\', and the cert_path in database is 'C:\Program Files\ManageEngine\SharePoint Manager Plus\conf\YourCertName.pfx', the new location of the certificate file will be 'D:\SharePoint Manager Plus\conf\YourCertName.pfx'.

6.      Update the path in the database by running this command in the database console for each Microsoft 365 Tenant configured.
Update AzureAppCredentials set cert_path = '<New Certificate Location>' where farm_id = '<Tenant Admin Url>';










                  New to ADManager Plus?

                    New to ADSelfService Plus?

                      • Related Articles

                      • How to migrate SharePoint Manager Plus database from PostgreSQL to MS SQL

                        By default, SharePoint Manager Plus comes bundled with the PostgreSQL database. This page will explain how you can migrate SharePoint Manager Plus database from PostgreSQL to MS SQL. The following versions of MS SQL are supported by SharePoint ...
                      • How to granularly delegate SharePoint activities to non-administrative users

                        SharePoint Manager Plus offers non-invasive delegation where you can granularly delegate activities to non-administrative users. By assigning a role to a technician, they can perform only the activities associated with that particular role.SharePoint ...
                      • How to copy or move permissions between users

                        The addition of a new team member involves granting them permission to access shared team resources. This can be done by simply copying all the permissions from any of the team members to the new team member. You can also copy permissions from one ...
                      • How to check user and group permissions

                        When permission inheritance breaks, it paves the way to make SharePoint more secure. However, it's also a hindrance to administration as it often demands you look up and ensure that each user or group has access to only what is necessary. Looking up ...
                      • How to copy users between groups

                        Instead of adding one user at a time into a SharePoint group, you can directly copy users from one SharePoint group to another across different site collections. Steps to copy users between groups: Click on the Management tab. Under Groups ...