Error ID

Error

Root cause and troubleshooting steps

1000

ERROR_WHILE_GETTING_CONNECTION

Root cause: Connection could not be established with the MSSQL database.


Troubleshooting: Refer this page.

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 users with administrator privileges can create the Master key.

Troubleshooting: Provide the 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 for the database server or the database access permission for the specific user does not have permission to create a database.
Note: Users must have administrator privileges to create Master Key.

Troubleshooting: Provide the 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:

The Master Key password should be the same as the one which was given during the database creation. If you have forgotten the Master Key password, then refer the 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.

Troubleshooting: Contact support.

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