An error occurred while accessing the database 'xxx' because it is not available
Article # 3045990 - Page views: 51
Issue
Fuzzy searching is not working and the above error appears in validation form.
KSMS shows all databases as valid and Transformation Designer shows no validation errors and all databases are valid and working.
The validation form is mapped correctly to the relevant database.
Dev tools shows a 500 internal server error when you perform a search on the validation form.
Solution
Rename all the databases and references to databases inside Transformation Designer and KSMS to be the same.
Level of Complexity
Easy
Applies to
Product | Version | Build | Environment | Hardware |
---|---|---|---|---|
KTA | 7.7 |
Article # 3045990