Starting Helpdesk causes multiple SQL TABLKEY errors

Version 1
    Question

    Attempting to start Helpdesk.exe cause multiple error messages such as:

    SQLExec Direct

    TABLKEY [ODBC SQL Server Driver][SQL Server]Invalid object name 'TABLKEY'.

     

    and eventually crashes without starting.

    Answer

    This is caused because Helpdesk is unable to find the database tables it requires. Usually this is due to the database tables having the wrong owner, so if you have confirmed that the datasource is pointing to the correct database, and not Master, for example, try the following.

     

    Open the database in Enterprise Manager and check the owner of the tables and make sure that your ODBC connection is using the same credentials to login to the SQL server. Do note that this user has to be the database owner.

     

    If restoring a database in support centre then this is most often simply fixed by running a stored procedure  to change the owner of all the tables to dbo.

     

    To change table owners please see articles KB 1044 for SQL 2000 and 2005 or KB 40 for SQL 7

    Environment

    Helpdesk

    SQL Database