by Richard Edwards
Error: “Error 1 Connecting to the Database Profile” when running DB Load or DB Dump or no databases found, please run DB Setup when starting Sage 300
After installing Sage 300 Database Setup runs properly, especially if you get a UAC prompt, but DB Load or DB Dump won’t work with the error message “Error 1 Connecting to the Database Profile” and Sage 300 reports no databases found and says to run DB Setup. To resolve this issue, try the following:
Check sharing and permissions on the Shared Data Directory. Ensure the user you are connected as has Full Control (test by creating and then deleting a text file)
Run the affected program (DB Load, DB Dump, Sage 300) as Administrator
Optionally make these programs always run as Administrator, either for the current user or for All Users to prevent the issue from recurring
Alternately, have IT investigate to make sure Users in fact have Full Control of the shared data directory
Technical Details: Without proper access to the Shared Directory, the system cannot access browse.ism, which holds the database profile.