License Upload error - HY024

Deep

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.

kine

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.

DenSter

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.

kriki

[Topic moved from Navision forum to SQL General forum]