MachPanel Knowledgebase

MachSync Installation Guide

zohaib.shaikh — Thu, 28 Mar 2024 20:35:40 GMT

Summary

This article provides details on how to install MachSync Utility.

Applies To

This article applies to MachSync v1.0.

General Purpose of MachSync Utility

MachSync supports Cross Forest multi-targeting Active Directory user synchronization. It refers to the process of synchronizing user accounts across multiple Active Directory (AD) forests. In large organizations or those with complex IT infrastructures, it's not uncommon to have multiple AD forests due to mergers, acquisitions, or other reasons. Each forest might have its own set of user accounts, groups, and resources.

Synchronizing user accounts across these forests allows for a unified identity management system, enabling users to access resources in any of the forests with a single set of credentials. This synchronization typically involves replicating user account information, including attributes such as usernames, passwords, group memberships, and other relevant data.

The goal of MachSync is to manage and simplify cross-forest multi Active Directory synchronization and is to streamline identity and access management, improve security, and enhance user experience by providing seamless access to resources across disparate AD forests.

MachSync Post Installation Steps/Configuration

If you have already installed MachSync, please follow the MachSync Configuration guide from link below:

MachSync Configuration Guide

Pre-Requistes

Ensure .Net 4.8 is installed. Default selected sub features are sufficient.

Download and Install VC_redist.x64 VS2019 from here.

MachSync Installation

Download MachSync Installer from our Website/MachSol portal. Check Instructions here...

You will need to go to https://www.machsol.com/machsol-solution-for-identities-synchronization/
Click on SIGN IN on right top of page.
Provide registered "Email ID" with MachSol Inc. which is also known as Primary Contact. (Emailid@Yourdomain.com). Enter your details and click on Login. You can also reset password by clicking on Forgot Password.

MachSync Installation Types:

There are three different types of installations:

All in one (MachSync Studio, Service, and password capture utility)
MachSync Studio and Service Only
Password Capture Utility Only.

This installer contains all three types and asks you during setup.

Note:

Recommended topology: Install "MachSync Studio and Service Only" on domain joined PC, and "Password Capture Utility Only" on all DCs (PDC, ADCs).

Alternative approach: Install "MachSync Studio, Service and Password capture utility" on PDC, and install "Password Capture Utility Only" on all ADCs.

Test scenario explained in MachSync Configuration Guide covers two domains with single domain controller (Option 1 shown in image below) .

Option 1: You have single domain controller on both domains.
Option 2: You have PDC and ADCs on both domains.
Option 3: You add a "Domain Joined PC" and install the "MachSync Studio and Service Only" option on it, then install the "Password Capture Utility Only" on the domain controllers.

1 - All in one (MachSync Studio, Service and Password capture utility).

This type of installation can be done on "Primary domain controller". Please follow below step to install MachSync:

Double click the installer to install MachSync.

On "Welcome to MachSol MachSync installer wizard" page, click Next.

On "License Agreement" page, Accept the agreement and click Next.

Select Installation Type: All in one (MachSync Studio, Service, and Password Capture Utility), and click Next.

Select installation folder or leave default. then Click Next

Review Settings. Click Next to Install.

Click Finish to Complete setup.

After installation you will see the "MachSync Configuration Studio".

Before you can start using MachSync, you need to Activate MachSync License. Please review below KB:

MachSync License Activation

2 - MachSync Studio and Service Only

You need to use this option for deployment scenario where you want to use a "Domain Joined PC", i.e. MachSync Studio and Service only.

Double click to install MachSync.
On welcome MachSync installer wizard page, click Next.
Select Installation Type: MachSync Studio and Service only

Select installation folder. Click Next
Review Settings. Click Next to Install.

Click Finish to complete setup.
After installation finish a screen will appears and "MachSync Configuration Studio" will open.

Before you can start using MachSync, you need to Activate MachSync License. Please review below KB:

MachSync License Activation

3 - Password Capture Utility only

You need use this option for all Secondary / Additional Domain Controllers in case of using a "Domain Joined PC" model.

Double click to install MachSync.
On welcome MachSync installer wizard page, click Next.
Select Installation Type: Password Capture Utility only

Select installation folder. Click Next
Review Settings. Click Next to Install.

You will see message to copy 'AppConfig' folder from "PDC" or "Domain Joined PC" where configuration was saved then you will be asked to restart the system to load password capture module/utility.

Click Finish to complete setup.

MachSync Post Installation / Configuration

The next step after the installation is the configuration of MachSync using below KB article:

MachSync Configuration Guide

Guide for Installation and Configuration of ADSync

mudesira.munir — Mon, 04 Dec 2023 11:32:19 GMT

01. Download ADSync Tool From MachSol Customer Portal

02. WebHelp/Manual for ADSync v6

03. ADSync – Installation Guide

04. ADSync – Configuration Guide

05. Add ADSync Templates

06. Logging Supported by ADSync

07. ADSync Important Notes and Troubleshooting

08. ADSync Utility Update to v6.0

09. Remove and Disable ADSync

Post Installation Steps (to fix sql-server-identity-jumping-1000-identity_cache)

Khurram.hameed — Mon, 16 Mar 2020 08:30:17 GMT

Summary

This article is a step by step guide to perform post installation SQL Server steps

Applies To

This article applies to all SQL Server versions

Issue

There is issue noticed in SQL database with table identities that are jumping values.

10,000 Jump:

Due to this, in our sample scenario 6585 rows are taking 26879 primary key values:

This is an issue with SQL Server and similar issue is explained on link below:

https://blog.sqlauthority.com/2018/01/24/sql-server-identity-jumping-1000-identity_cache/

Fix

Please login as SA or Db Admin, select MachPanel_DB (or whatever the DB name) for your installation

Scenario A: SQL Server version 2017 or Later:
Run below command to turn Identity Cache to Off.

ALTER DATABASE SCOPED CONFIGURATION SET IDENTITY_CACHE=OFF;
GO

Scenario B: SQL Server versions Earlier than SQL Server 2017:
Perform following steps

Open up the SQL Server Configuration Manager
Click the left side of the SQL services in the below image.
Right click on the SQL Server instant name at the right pane as shown in the above image. Default value is: SQL Server (MSSQLSERVER),
Click the Properties option as shown in the above image.
Click the Startup Parameters tab as shown the below image.
Type -T272 in the Specify a startup parameter Textbox field and click Add
–T272 parameter will appear in the Existing parameters section as shown in below image.
Click the Apply button and you will get the below Warning.
Click OK, as Warring message pops up, and Restart the SQL Server instant service.

Installation Guide for Microsoft SQL Server 2017/2019 Express

zohaib.shaikh — Sun, 15 Mar 2015 09:54:24 GMT

Summary

This article is a step by step guide for installing SQL 2017 Express.

Applies To

This article applies to SQL Server 2017 and SQL Server 2019.

List of anti virus Exclusion for SQL Server:

For Microsoft SQL Server, review details on link below for exclusions list:
https://support.microsoft.com/en-us/help/309422/choosing-antivirus-software-for-computers-that-run-sql-server

Steps to install SQL 2017/2019 Express

Step 1:

Download SQL Server Express Setup (2019) from: https://go.microsoft.com/fwlink/?linkid=866658

Download SQL Server Express Setup (2017) from https://www.microsoft.com/en-us/download/details.aspx?id=55994

Select English as Language and Express Core SQL Server Engine Only option (Default Option). Download and Save file to c:\ drive.

Step 2:

Once Download is completed, click Close. Copy downloaded installer “SQLEXPR_x64_ENU.exe” to c: drive. Open command prompt and point to c: drive.

Replace strong alpha numeric password in command below, copy/paste in command prompt and click enter to run installer.

SQLEXPR_x64_ENU.exe /QS /ACTION=Install /INSTANCENAME="MachPanelSQL" /FEATURES="SQLENGINE" /SQLSVCACCOUNT="NT AUTHORITY\SYSTEM" /SQLSYSADMINACCOUNTS="NT AUTHORITY\SYSTEM" /AGTSVCACCOUNT="NT AUTHORITY\Network Service" /IACCEPTSQLSERVERLICENSETERMS /IACCEPTROPENLICENSETERMS /SAPWD="STRONGPASSWORDHERE" /SECURITYMODE=SQL /TCPENABLED=1 /NPENABLED=1 /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /ADDCURRENTUSERASSQLADMIN=1

Please execute the installer as “Run as Administrator” and select the first option from the installer “New SQL Server Standalone Installation’.

Step 3: In the second step agree to the License terms and then click Next. Then check for the updates, if available then download the Updates and Install the setup files.

Step 4: On the next page “Microsoft Update” please check the highlighted option in order to use the recommended option regarding updates and click Next.

Step 5: In the fourth step the installation wizard will automatically install the Install Rules and upon completion please click on Next.

Step 6: Next up here is the Feature selection. In this step please select the required features as highlighted which are required for MachPanel database. Features to be selected: Database Engine Services, Client tools connectivity & Client tools backward compatibility and then click Next.

From Instance features please select: Database Engine Services

From Shared features please select: Client tools connectivity & Client tools backward compatibility and click Next.

Step 7: In the Instance Configuration please select the default instance option as shown below and click Next. If you have already created an instance then please use named instance option and provide the Instance Id as well otherwise default instance will work.

Step 8: In this step you will review the account properties as there will be different accounts for different SQL server services. Please proceed with below highlighted setting in service accounts tab as we used Default instance so the properties of the accounts should be like:

Under the Collation tab please make sure to select the SQL_Latin1_General_CP1_CI_AS as shown below and click Next.

Step 9: The next step is the Database Engine Configuration. Under Server Configuration tab please select the Authentication Mode as Mixed mode which includes both SQL server authentication and Window authentication and provide the password for Server Administrator (SA) account. It is recommended to provide a strong password and also save it in some safe place. There should be one SQL server administrators specified, you can add multiple by clicking on Add button.

Step 10: After the database configuration settings are configured the installation wizard will itself install feature configuration rules and then the installation will proceed and complete.

SQL Server Management Studio Installation:

After SQL server Installation we will have to install the SQL server management studio by running the exe file as an Administrator and click on Install.

To install SQL Server Management Studio Setup (18.4), use below link to download installer: https://aka.ms/ssmsfullsetup

The setup will complete on its own and do not require any input from client.

ADSync installation and involved Server roles

mudesira.munir — Wed, 25 Jun 2014 02:20:27 GMT

Summary

This article provides information for ADSync installation and the involved Server roles.

Applies To

This article applies to ADSync.

Scenario:

As mentioned in installation documentation, ADSync needs to be installed on the Primary Domain Controller (PDC) and if available on the other (additional) Domain Controllers. It can and does happen that the role of PDC gets demoted in case of for example Server updates or other reasons. What are the dependencies/relationships here between the PDC installation and additional Server installations?

Questions:

Do we need to change anything / reinstall anything if software is also installed on additional Servers in case PDC is demoted?
If one of the additional Servers gets promoted to PDC does one have to change anything on the old PDC?

Solution:

There are two possible cases and steps are needed for both cases based on above scenarios:

Case 1: PDC Server is completely gone and being replaced by and ADC:

The steps required are:

Copy “SyncConfiguration.xml” file from PDC/ADC to some secured location
If ADSync was already installed on ADC as ADC server role, then uninstall the utility and reinstall with PDC role option selected from ADSync installer
Once installation is completed then place “SyncConfiguration.xml” file inside the installation directory.

Case 2: You want to switch PDC/ADC role.

Switch roles for DC and do not change ADSync, it will work.

ADSync – Installation Guide

mudesira.munir — Tue, 12 Mar 2013 00:10:20 GMT

Summary

This article provides you information regarding the Installation of ADSync.

Applies To

Applies to ADSync V 4.0/4.1/4.2/4.3/5.0/5.1 and 6.0.
ADSync latest version is 6.0.
Latest MachPanel build v7.2.35 supports latest ADSync v6.0.

Reboot Required

Yes: You must Reboot ALL Domain Controllers (Primary and Additional) where ADSync tool is installed at least once.

Description

ADSync is a utility consisting of multiple components used to synchronize local active directory objects with Hosted/Cloud Active Directory objects. ADSync utility v6.0 will sync Multiple OU's in a client\local AD with Hosted OU.

Types of object(s) which are currently synchronized.

User Accounts
Groups

The data fields which are being synchronized through this utility for User Accounts are:

Description
Display Name
First Name
Last Name
Email
Initials
Middle Name
UserPrincipalName(UPN)
Direct Manager
Home Phone
Mobile Phone
Business Phone
Pager
Home Page
Fax
Address
City
Country
State
Zip Code
Company
Job Title
Department
Office Location
Password
Notes
Proxy Addresses [
- SIP Address
- EUM Address
- SMTP Address ]
AD User Enabled
Thumbnail Image
Logon Hours
Use email to generate UPN {'Use Email to Generate UPN' is not attribute rather a configuration setting to to set user's UPN on hosted side using 'Email' attribute at the time of creation.}

The data fields which are being synchronized through this utility for Groups are:

Name
Display Name
Type
Members

ADSync Installation Type

There are two different installations:

Primary Domain Controller
Additional Domain Controller.

This installer contains both the utilities and asks you for installation type during setup.

Note: You must install ADSync tool on your Primary Domain Controller and on all of the Additional Domain Controllers. 1st install ADSync and configure it on Primary Domain Controller and follow instructions below for Additional Domain Controller(s)

Installation of Active Directory Sync Utility

Install .Net Framework 3.5 features as shown below:

Save

This utility requires Microsoft Visual C++ 2010 x64 to work, it is installed if not already present on the server. Please click Install button to start download and installation of Microsoft Visual C++ 2010 on this machine.

After pre-requisite verification and installation, installer will start setup for AD Sync utility. Click Next to start the setup.

Select Installation Type

Select installation folder.

Review Settings. Click Next to Install.

After installation finish a screen will appears and ADSync Configuration Studio will open; if installation is for Primary Domain Controller.

References

ADSync – Configuration Guide: http://kb.machsol.com/Knowledgebase/Article/50351
You an also download ADSync Installation Guide.chm from attachment below.

Download

ADSync is a separate module and costs may apply. Kindly contact sales for further information.

List of anti virus exclusions for ADSync

Applications:

C:\Program Files\ADSync\ADSyncSvc.exe
C:\Program Files\ADSync\ADSync.ConfigStudio.exe
C:\Program Files\ADSync\SyncConfigurations.xml

Folder:

C:\Program Files\ADSync\logs OR as per log folder configuration in ADSync Configuration studio.

MachPanel Remote Server Installation

mudesira.munir — Mon, 11 Apr 2011 08:00:03 GMT

Summary

This article describes detailed steps to Install MachPanel Remote Server.

Applies To:

MachPanel build v7 and above

System Requirements:

For best performance of MachPanel Automation Solution, make sure your system meets below Minimum RAM requirements:

Role

Minimum System Requirements

Software Needed

MachPanel Remote Server

This is the server that is to be managed by MachPanel (Exchange, Skype for Business etc.).

RAM: 4 GB

STORAGE:10 GB

(amount of free space is recommended for remote installation files, backups and logs etc.)

Windows Server 2008 R2 Standard Edition or later i.e. (Enterprise, Datacenter, Itanium)

MachPanel Installation is also supported on:

Windows Server 2012 or later
Windows Server 2016
Windows Server 2019
Windows Server 2022

Microsoft .Net Framework:

Microsoft .Net Framework 3.5 and higher
Microsoft .Net Framework 4.5.2 is mandatory and must be installed. This is not the same as .Net 4.5 under windows in features.This version of the .NET Framework runs side-by-side with the .NET Framework 3.5 SP1 and earlier versions, but performs an in-place update for the .NET Framework 4, .NET Framework 4.5 and .NET Framework 4.5.1.

Firewall Setup

Direct communication between control and remote servers over IP will be required.

Our MachPanel Provisioning Service binds with IP on NIC to create a Socket/TCP Channel over the selected IP and then communication is established between servers via this service.

Ports to Open

Protocol: TCP

Port Number: 7860

Direction: Inbound/Outbound between all Control and Remote Servers.

Addresses to Allow

Below URLs must be accessible on Control Panel server(s) and Remote server(s) in order to Sync Licenses and perform updates.

https://ls.machsol.com/webservice/lic.asmx
https://ls2.machsol.com/webservice/lic.asmx
https://updates.machsol.com
https://www.machsol.com
https://machsol.com

Microsoft Exchange:

For Exchange 2007 and Exchange 2010, MachPanel Remote Servers should be installed on Exchange Mailbox Server.
For Exchange 2010 Hosted, MachPanel Remote Servers should be installed on the CAS Servers.
For Exchange 2010 Non-Hosted\2013\2016\2019, MachPanel Remote Servers should be installed on Exchange Mailbox Server.

Microsoft Skype4B(Lync):

In case of LYNC 2010 Standard Edition deployment, MachPanel Remote Server will be deployed on SE Server
In case of LYNC 2010 Enterprise deployment, MachPanel Remote Server can be installed on server where LYNC Management Shell is available (like on FE)
In case of LYNC 2010 Multi-tenant Pack, MachPanel Remote Servers should be installed on all Front End and Director Servers.
In case of LYNC 2013, MachPanel Remote Servers should be installed on all Front End.
In case of Skype for Business 2015/2019, MachPanel Remote Servers should be installed on all Front End servers.

Microsoft SharePoint:

In case of server farm, MachPanel Remote Server will be installed on Web Front end Box.
In case of single server deployment, MachPanel Remote Server will be installed on that same server.

Microsoft CRM:

For CRM, MachPanel Remote Server should be installed on Application Server (Platform Server Role)

Hyper-V Host:

For Hyper-V, MachPanel Remote Server should be installed on every Hyper-V host server that needs to be integrated with MachPanel Control Panel.

Web Hosting Server:

MachPanel Remote server should be installed on all the servers where Web Hosting services (IIS, FTP, Databases, DNS etc.) are installed.

Procedure:

Follow the step by step procedure to install MachPanel Remote Server:

1) First step you need to install .NET Framework Features. For this, open Server Manager, click on 'Features' and click on 'Add Features': MachPanel now needs .Net 4.5.2 which is installed separately and you will get error in updates if this is not installed. https://www.microsoft.com/en-us/download/details.aspx?id=42643

The HTTP activation and Non-HTTP activation and the latest available .net version (4.5 for windows 2012 and 4.6 for windows 2016) should also be installed. See below snapshot for more details:

Finish the setup. Now your server is ready to install MachPanel Remote Server.

2) Now open http://www.machsol.com/ and click on Login link on top. Login using the credentials you registered with this site:

Save

3) Click on 'Downloads' from the 'Products' section.Download link is only visible to Primary Contact (which is a registered contact at MachSol).

Note:You will be able to download the product only when the account isapproved by our sales team i.e. primary contact. Please contact the sales team to get thedownload section activated.

3) Select the appropriate MachPanel Remote Server 32 bit or 64 bit setup, download it and run it.

4) Follow the screenshots below to complete the rest of the setup. Click MachPanel_Remote_Server_x64_6.0.36.exe to run setup.

Click Next to continue

Accept License agreement and click Next to continue

Select the Destination Folder and click on Next

Review the setup summary and click Next

Bind Remote Server to the local IP of machine.

Click Finish. The installation of MachPanel Remote Server is complete.

*UPDATE:

This will install MachPanel Version 7.2.35. However to avail more features,update to our latest build by following below KB article

http://kb.machsol.com/Knowledgebase/Article/50268

List of anti virus exclusions for MachPanel Remote Server (x64)

Applications:

C:\Program Files\MachSol\MachPanel Remote Server\MachSol.MachPanel.RemoteConfigurationStudio.exe
C:\Program Files\MachSol\MachPanel Remote Server\MachSol.MachPanel.Provisioning-Svc.exe
C:\Program Files\MachSol\MachPanel Remote Server\MachSol.MachPanel.v45Wrapper.exe

Folders:
C:\Program Files\MachSol\MachPanel Remote Server\logs

MachPanel Control Server Installation

rehan_waseem — Sun, 10 Apr 2011 13:38:04 GMT

Summary

This article describes step by step procedure to install MachPanel Control Server.

Applies To:

MachPanel Version 7 and above

System Requirements:

For best performance of MachPanel Automation Solution, make sure your system meets below Minimum RAM requirements:

Role	Minimum System Requirements	Software Needed
MachPanel Control Server	RAM: 8 GB (with SQL) 4 GB (without SQL) STORAGE: 50 GB (with SQL) 30 GB (without SQL) (amount of free space is recommended for control server installation files, SQL Files, backups and logs etc.)	Windows Server 2025 Standard Edition or later i.e. (Datacenter, Datacenter: Azure Edition) MachPanel Installation is also supported on: Windows Server 2012 or later Windows Server 2016 Windows Server 2019 Windows Server 2022 Microsoft .Net Framework: Microsoft .Net Framework 4.8 is mandatory and must be installed. Microsoft .Net Framework 4.8 on control and remote servers.
Firewall Setup	Ports to Open	Addresses to Allow
Direct communication between control and remote servers over IP will be required. Our MachPanel Provisioning Service binds with IP on NIC to create a Socket/TCP Channel over the selected IP and then communication is established between servers via this service.	Protocol: TCP Port Number: 7860 Direction: Inbound/Outbound between all Control and Remote Servers.	Below URLs must be accessible on Control Panel server(s) and Remote server(s) in order to Sync Licenses and perform updates. https://ls.machsol.com/webservice/lic.asmx https://ls2.machsol.com/webservice/lic.asmx https://updates.machsol.com https://www.machsol.com https://machsol.com

Procedure:

Please follow the step by step procedure to install MachPanel Control Server on your windows server machine:

1) First step is to install the pre-requisite i.e. Web Server. For this, open Server Manager, click on 'Roles' and click on 'Add Roles'

2) Then select 'Web Server (IIS)' and click next.

3) Now select all the role services for Web Server except 'FTP Services'.

4) Click 'next' to install the selected role and services.

5) Now go to Server Manager >> Features. Select and install .NET Framework 4.8 Features. For Windows Server 2012, the HTTP activation and Non-HTTP activation should also be installed. See below snapshot for more details:

Finish the setup. Now your server is ready to install MachPanel Control Server.

6) Now open http://www.machsol.com/ and click on Login link on top. Login using the credentials you registered with this site.

Save

6) After login, click on the 'Downloads' from 'My Accounts'. Download link is only visible to Primary Contact (which is a registered contact at MachSol).

Note: You will be able to download the product only when the account is approved by our sales team. Please contact the sales team to get the download section activated.

7) Select suitable (64 bit or 32 bit) MachPanel Control Server setup and download it.

8) When the download completes, run the setup.

9) Click 'Next'

Save

10) Accept the End-User License Agreement and click 'next'.

11) Now, you have TWO types of installation for MachPanel. One is SQL Server 2017 or 2018 installation (Typical) the other is Secondary Server for load balanced server.

If you want to install SQL Server by yourself or want to put MachPanel database on some other database server then select 'Typical'.
If you want High availability ( Load Balanced ) and install a secondary MachPanel then choose "Secondary Server".

Typical Installation:

MachPanel database can also be installed on same or on a separate machine to use during setup. For this, you will need to install the MSSQL Server 2008 R2 or higher along with management tools (MSSQL Management Studio) and provide us details like IP address and Password of SQL Server, Instance Name and Password of Server Admin(SA) so that the MachPanel installer can create MachPanel database on the existing SQL server.

Database Requirements:

MachPanel Requires MSSQL 2019 or MSSQL 2017. Install by selecting English as Language.

Other Requirements:

Security Mode: Mixed Mode (allows both windows and SQL Authentication)
SQL Collation: SQL_Latin1_General_CP1_CI_AS
Lastly, Install SQL Server Management Studio 18

NOTE: The SQL Server Collation MUST be SQL_Latin1_General_CP1_CI_AS for ANY Version of SQL Server. You will have to change this later on your own if this is not set up properly at start. Also it's necessary to have SQL in ENU for any version in case of Typical installation. https://kb.machsol.com/Knowledgebase/53483/Installation-Guide-for-SQL-2017-Express

Below below steps to complete the rest of installation for 'Typical' installation:

1) Select location for MachPanel installation. Default location is recommended.

2) Provide the SQL Server details : SQL Server name & instance, 'SA' username and password (Note that SQL Server must have been set up on default port i.e. on port 1433, if not then change it to port 1433 and then continue with the setup). After providing the requires details click 'Next'.

3) Review the setup summary and click 'next' to start the installation.

Finalizing Installation:

1) When the setup finishes, below form will appear.

Fill the form and be careful in filling the Provider login and password. This will be used for authentication when using the panel. You can provide login as : 'provider@yourdomain'. After filling the form 'Save' it.

2) Please Activate MachPanel Licenses by providing the Email address registered with MachSol.

3) Final Step (Post Installation Step):

Once installation is finished, follow the Post Installation Steps on SQL discussed on link below:

https://kb.machsol.com/Knowledgebase/55627/Post-Installation-Steps-to-fix-sqlserveridentityjumping1000identitycache

*UPDATE: This will install MachPanel Version 8.0.32. However to avail more features, update to our latest build by following below KB article:
http://kb.machsol.com/Knowledgebase/Article/50181

List of anti virus exclusions for the MachPanel Control Server (x64)

Applications:

C:\Program Files\MachSol\MachPanel Control Server\bin\MachSol.MachPanel.ConfigurationStudio.exe
C:\Program Files\MachSol\MachPanel Control Server\Bin\MachSol.MachPanel.Provisioning-Svc.exe
C:\Program Files\MachSol\MachPanel Control Server\Apps\O365\MachSol.O365.WrapperService.exe
C:\Program Files\MachSol\MachPanel Control Server\Bin\MachSol.MachPanel.License-Svc.exe
C:\Program Files\MachSol\MachPanel Control Server\Bin\MachSol.MachPanel.HelpDesk-Svc.exe
C:\Program Files\MachSol\MachPanel Control Server\Bin\MachSol.MachPanel.Billing-Svc.exe
C:\Program Files\MachSol\MachPanel Control Server\Bin\MachSol.MachPanel.Network-Svc.exe

Folders:
C:\Program Files\MachSol\MachPanel Control Server\logs

SQL Server:
For Microsoft SQL Server, review details on link below for exclusions list:
https://support.microsoft.com/en-us/help/309422/choosing-antivirus-software-for-computers-that-run-sql-server

SaveSav

MachPanel Knowledgebase

MachSync Installation Guide

Summary

Applies To

General Purpose of MachSync Utility

MachSync Post Installation Steps/Configuration

Pre-Requistes

MachSync Installation

MachSync Installation Types:

1 - All in one (MachSync Studio, Service and Password capture utility).

2 - MachSync Studio and Service Only

You need to use this option for deployment scenario where you want to use a "Domain Joined PC", i.e. MachSync Studio and Service only.

3 - Password Capture Utility only

MachSync Post Installation / Configuration

Guide for Installation and Configuration of ADSync

Post Installation Steps (to fix sql-server-identity-jumping-1000-identity_cache)

Summary

Applies To

Issue

Fix Please login as SA or Db Admin, select MachPanel_DB (or whatever the DB name) for your installation

Installation Guide for Microsoft SQL Server 2017/2019 Express

Summary

Applies To

List of anti virus Exclusion for SQL Server:

Steps to install SQL 2017/2019 Express

SQL Server Management Studio Installation:

ADSync installation and involved Server roles

ADSync – Installation Guide

Summary

Applies To

Reboot Required

Description

ADSync Installation Type

References

Download

List of anti virus exclusions for ADSync

MachPanel Remote Server Installation

Summary

Applies To:

System Requirements:

Procedure:

*UPDATE:

List of anti virus exclusions for MachPanel Remote Server (x64)

MachPanel Control Server Installation

Summary

Applies To:

System Requirements:

Procedure:

Finalizing Installation:

List of anti virus exclusions for the MachPanel Control Server (x64)

Fix

Please login as SA or Db Admin, select MachPanel_DB (or whatever the DB name) for your installation