License Upload error - HY024

Deep
Deep Member Posts: 569
edited 2008-04-07 in SQL General
Dear All,

I am facing a problem while uploading the clients license file on his SQL server database.
The system shows an error "ODBC SQL Server Driver: Database is invalid or cannot be accessed. State ID: HY024."
Please help me out over this so that I can resolve this error.
Regards,

Deep
India

Comments

  • kine
    kine Member Posts: 12,562
    1) Be sure that you have sysadmin privileges on the SQL to upload the license into master database
    2) When you are opening the database, be sure, that you used exactly the name of the DB (including upper/lower case) - it will open correctly if you enter it manually with different cases, but sometime it is source of problems.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • DenSter
    DenSter Member Posts: 8,307
    Like Kamil says, the license is uploaded into the Master database, so you will need to have proper permissions in there. I always give users db_owner on Master, you don't have to be system admin. You might even get away with just datawriter. For sure you need to add Master to the user mapping.
    Daniel Rimmelzwaan
    RIS Plus, LLC
  • kriki
    kriki Member, Moderator Posts: 9,121
    [Topic moved from Navision forum to SQL General forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories