Check to make sure you're pointing to the correct db when you enter Emerald.
Normally it is called 'emerald' or 'emerald25'. Next, make sure you have
permissions set to select the tables. You can go into the SQL Enterprise
Manager, go to the Emerald db, right click on it and choose Edit. Then click
on the Permissions tab. You should see an Emerald group(s) with a list of
users who can access that group. The userid you sign on to Emerald with should
be in there with checks allowing access.
For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html