Error: java.sql.SQLException: Cannot find the symmetric key 'ZOHO_SYMM_KEY', because it does not exist or you do not have permission.
Error Message:
Possible Cause:
This issue could occur if there is any mismatch with master key.
Resolution:
A. For AD Manager Plus Build is 7100 and above:
1. Stop the product.
2. Take a back up of "conf/customer-config.xml" and update the existing property inside <configuration name="mssql" > as given below
<property name="masterkey.password" value="YOUR_PASSWORD_HERE" />
<property name="masterkey.open" value="true" />
5. Save the file and try migrating the database with ordinary steps.
B. For AD Manager Plus Build below 7100:
1. Stop the product
2. Go to ADManager Plus folder -> conf -> persistance -> persistance-configuration.xml
3. Search for "<property name="sqlgenerator" value="com.adventnet.db.adapter.mssql.MssqlSQLGenerator"/>"
4. Below the searched line , paste the below lines,
<property name="masterkey.password" value="YOUR_PASSWORD_HERE" />
<property name="masterkey.open" value="true" />
5. Replace 'YOUR_PASSWORD_HERE' with the password obtained from your SQL server.
6. Save the file and try migrating the database with ordinary steps.
Note: The password should meet the MSSQL password complexity. For more information on Microsoft SQL complexity, please refer to this document.
If the problem still persists, contact support@admanagerplus.com.
New to ADSelfService Plus?
Related Articles
While generating a report when MS SQL database is deployed, a blank screen or "There is no matching data for your input(s)" error is displayed
Ensure that the product is running before executing the troubleshooting steps listed below. In the machine where ADManager Plus is installed, start a Command Prompt as an administrator. Test the connectivity between ADManager Plus and MS SQL server ...Error: Pg_Ctl does not exist or being used by some other program
Error Message: Pg_Ctl does not exist or being used by some other program Possible Cause: This error message would appear if we do not have sufficient permissions to start up ADManager Plus or to upgrade it. This error message could also occur if any ...How to integrate ADManager Plus with Zoho People and streamline user lifecycle management
By integrating ADManager Plus and Zoho People, users can be automatically created in Active Directory based on the user details entered in Zoho People. Apart from user creation, this integration also supports user account management actions. Actions ...SSL certificate error: The certificate does not have a private key installed.
Error : SSL certificate error: The certificate does not have a private key installed. Possible Causes : 1. If the private key is missing, it could mean that the SSL certificate is not installed on the same server which generated the Certificate ...SSL certificate Error: An unexpected error occurred.
Error message: SSL certificate Error: An unexpected error occurred. Please contact support@admanagerplus.com Possible causes: The generated certificate might not have a private key installed. The Subject Alternative Name (SAN) might not have been set ...