-
Title
"Access denied", cannot connect via root after installation. -
Description
After installing(reinstalling) Toad Intelligence Central from the BI Suite, a connection to root@localhost cannot be made and there is no access to other uses and objects. "Access denied" error, or another error noting that a hub object cannot be found or executed, is given but the services have been started without any issue. -
Cause
Corruption of installation file.
Migration of corrupted Program Data directory that had been backed up incorrectly could have further corrupted the installation.
-
Resolution
WORKAROUND 1:
Make sure to shut off the 3 Toad services before moving/changing the ProgramData directory (when migrating previous Toad Intelligence Central data and connections). Re-start the services after the migration and before launching the Console.
Note: When migrating the setting, both the Data and the Conf folders needs to be migrated together.
WORKAROUND 2:
If there is another set of ProgramData files that had been backed up, those may be used in another attempt to migrate connections and data.
Troubleshooting - Use command line to launch mysql.exe from the TIC Program Files folder (i.e. C:\Program Files (x86)\Dell\Toad Intelligence Central\bin) and tryto select * from hub_information_schema.<object referred to by the error message>.
If this also errors out, there may be a problem with the migrated ProgramData files (i.e. C:\ProgramData\Dell\Toad Intelligence Central). The previous data and connections cannot be migrated over based off that set of backup files.
-
Additional Information
The corruption of the ProgramData files may not have occurred because of an issue with Toad itself. In reported cases, it was due to problems that occurred in the environment or a bad back up process.