The following table depicts the common errors and steps to troubleshoot.
|
Error ID
|
Error
|
Root cause and troubleshooting steps
|
|
1000 |
ERROR_WHILE_GETTING_CONNECTION |
Root cause: Connection could not be established with the MSSQL database. |
|
1001 |
ENCRYPTION_NOT_SUPPORTED |
Root cause: Master Key is supported only for versions greater than 2000 in MSSQL
Troubleshooting: Upgrade MSSQL to version higher than 2000.
|
|
1002 |
MASTER_KEY_NOT_CREATED |
Root cause: The Master Key is not created.
Note: Only admin can create the Master key. Troubleshooting: Provide Master Key password which matches your MSSQL installed machine's Password Policy.
Check if the user has the "dbcreator" role.
|
|
1003 |
CREATE_MASTER_KEY_FAILED |
Root cause: Error when creating the Master key. Some causes for this could be the specified master key may not satisfy the windows password policy of database server or the database access permission of the user specified for connection is not of DB create permission. Note: User must have an admin privilege to create a Master Key. Troubleshooting: Provide Master Key password which matches your MSSQL installed machine's Password Policy.
Check if the user has the "dbcreator" role.
|
|
1004 |
OPEN_MASTER_KEY_FAILED |
Root cause: The Master Key failed to open. Please specify the correct Master Key password that was used to configure the database. Troubleshooting:
Master Key password should be same as the one which was given during the database creation. If you have forgotten the Master Key password, then refer (altering master key query). |
|
1005 |
ASSOCIATE_MASTER_KEY_WITH_SERVICE_MASTER_KEY_FAILED |
Contact support |
|
1006 |
CERFICATE_NOT_CREATED |
Root cause: Certificate is not created in the database.
Troubleshooting: Contact support.
|
|
1007 |
CREATE_CERTIFICATE_FAILED |
Root cause: Certificate already exists or open Master Key command should have failed. Troubleshooting: Contact support.
|
|
1008 |
OPEN_CERTIFICATE_FAILED |
Root cause: Certificate doesn't exist or Master Key is closed. |
|
1009 |
SYMMETRIC_KEY_NOT_CREATED |
Root cause: Symmetric key is not created in the database. Troubleshooting: Contact support.
|
|
1010 |
CREATE_SYMMETRIC_KEY_FAILED |
Root cause: Symmetric key already exists or open Master key command should have failed. Troubleshooting: Contact support.
|
|
1011 |
OPEN_SYMMETRIC_KEY_FAILED |
Root cause: Symmetric key cannot be opened since the Master key is closed. Troubleshooting: Contact support.
|
|
1012 |
CLOSE_SYMMETRIC_KEY_FAILED |
Root cause: Symmetric key cannot be closed since the Master key cannot be closed.
Troubleshooting: Contact support.
|
|
1013 |
CREATE_EXTENSIONS_FAILED |
Contact support
|
|
1014 |
ERROR_WHILE_RETRIEVING_COLLATION |
Contact Support
|
|
1015 |
ERROR_WHILE_RETRIEVING_DATABASE_METADATA |
Contact Support |
|
1016 |
ERROR_WHILE_CREATING_STATEMENT |
Contact Support
|