An error occurred while accessing the database 'xxx' because it is not available

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