Configuring MSSQL Server

Microsoft SQL Server doesn't come bundled with SharePoint Manager Plus. However, you can configure SharePoint Manager Plus to use your existing or a new MS SQL instance as the backend database.

Prerequisites

• To use a Microsoft SQL server instance installed on a remote machine, install the corresponding SQL Server native client and command line utilities in the SharePoint Manager Plus machine based on the SQL Server version and CPU type of the machine.
• Copy the following files from the Microsoft SQL Server installation folder to the SharePoint Manager Plus\bin folder.
  • bcp.exe- <MS SQL Installation Dir>\Tools\Binn\bcp.exe
  • bcp.rll- <MS SQL Installation Dir>\Tools\Binn\Resources\1033\bcp.rll
• Open the TCP and UDP ports if a firewall is enabled on the SQL Server machine.The UDP Port is normally 1434.

Steps to be performed on Microsoft SQL Server:

• Open the SQL Server Configuration Manager.
• Go to SQL Server Services → SQL Server Browser, and ensure that the SQL Server Browser is running. Note: The SQL Server Browser runs as a Windows service and provides information on SQL Server instances installed on the machine.
• Go to SQL Server Network Configuration → Protocols for the particular database instance. Right click on the TCP/IP protocol to enable it. Restart the SQL Server Service for the change in setting to take effect.

Steps to change the backend database to Microsoft SQL Server in SharePoint Manager Plus

• Shutdown SharePoint Manager Plus.
• Go to SharePoint Manager Plus Home > \bin and enter changeDB.bat in command prompt. Provide the below details in the Database Setup wizard that opens.
  • Enter the Hostname of the SQL Server and select an instance from the list that appears.
  • Enter a name for the database.
  • Select between Windows and SQL Authentication.
  • Click Test to check if a connection can be established with the provided credentials.
• Click Save.

If the migration issue still persists

• Open command prompt and execute bcp.exe in <product-folder>/bin (e.g) C:\ManageEngine\SharePoint Manager Plus\bin
• If error message says "MSVCR120.dll, MSODBCSQL13.dll files are missing" when executing bcp.exe, it may be due to two reasons.
• Missing Visual C++ 2013 Redistributable Packages for Visual Studio: In this case install Visual C++ 2013 Redistributable Packages for Visual Studio from here.
• Missing Microsoft ODBC Driver for SQL Server: In this case install Microsoft ODBC Driver for SQL Server from here.
• If the bcp issue still persists, send the error screenshot to support@sharepointmanagerplus.com