SQL Master Key Password FAQs

SQL Master Key Password FAQs

  • How to create the master key password.

The user with dbcreator permissions can follow these steps to create the master key password:

Open MSSQL Server Management Studio, right-click the database and choose New Query

In the workspace, run the following query:

CREATE MASTER KEY ENCRYPTION BY PASSWORD='<new_Masterkey_password>';
The master key password must comply with the password policy of the MSSQL-installed machine. 

Top

  • How to change the master key password. 

The user with dbcreator permissions can follow these steps to change the master password:

Open MSSQL Server Management Studio, right-click the database and choose New Query

For regenerating the database master key and all other keys, run the following query:

ALTER MASTER KEY REGENERATE WITH ENCRYPTION BY PASSWORD='<new_Masterkey_password>';

To create an additional master key password, run the following query:

ALTER MASTER KEY ADD ENCRYPTION BY PASSWORD='<new-master_key>';

Note that after you create an alternative master key password, the old master key password will still be functional. 

Top

  • How to take backup of the master key password.

Open MSSQL Server Management Studio, right-click the database and choose New Query

 In the workspace, run the following query:

BACKUP MASTER KEY TO FILE = 'path_to_file' ENCRYPTION BY PASSWORD = '<Masterkey_password>';

Top

  • How to restore the master key password?

Open MSSQL Server Management Studio, right-click the database and choose New Query

In the workspace, run the following query:

RESTORE MASTER KEY FROM FILE = 'path_to_file' DECRYPTION BY PASSWORD = '<masterkey_password_of_backup_database>' ENCRYPTION BY PASSWORD = '<masterkey_password_of_restoring_database>';

The master key password will be restored to the database.

Top

  • Why does the master key password fail during upgrade? 

This can happen of the password doesn't comply with the password policy of the MSSQL-installed machine. 


      New to M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • How to reset Admin password (SDOrg) for SupportCenter Plus 11.0 version and above

                      This is applicable only above SupportCenter Plus 11.0 version. If you are using any other build , please contact support with the details. You can get the build number from About us present in the top right of the user interface. 1. Access your ...

                    • How to reset administrator password in ServiceDesk Plus MSP

                      Follow the below steps to reset Administrator password for builds more than 10600 (To reset the password for less than 10600. Please contact support. ) 1.Connect to the DB Server. i) For MS-SQL-Connect to the MS-SQL Server ii) For Postgres, go to ...

                    • How to reset administrator password in ServiceDesk Plus (or Asset Explorer).

                      1. Access your application server and browse to [your drive]:\ManageEngine\<application_name>\bin. 2. Click changeDBServer.bat. Information on the configured database will be displayed. If the database is MSSQL, go to the SQL Management Studio, go to ...

                    • The update option grayed out while restting the password

                      Sometimes, the update option will be grayed out while resetting the password. It could be due to the fact that the there is no valid license applied to the default Portal. Once the default portal is associated with the valid license, the update ...

                    • Backup password protection

                      The application backup is protected with a password. The password is required to open the backup file / restore it. This password can be changed in the Admin-> Backup schedule page. Click Edit Scheduling and input the backup password to change the ...

                      Related Products