Error: The following ODBC error occurred: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed State ID: HY024

I have written how to upload (and why to use Upload function) Dynamics NAV license file already. In the past, I have also have shown how to do this a number of times for consultants, developers and end-users. And once in a while, I would get another question – when I am trying to upload the license file, I get error message (screenshot below). Is the license file wrong? What did it do to my database?

Upload License File - Database is invalid error

I must admit, the error message looks scary (at least, it did for me, when I was trying to upload a new license to LIVE database for the first time – What?? Database is invalid?!), but in fact, the issue (and solution for it) is quite simple – you don’t have enough permissions on SQL server to upload the license file.

—————————
Microsoft Dynamics NAV Classic
—————————
The following ODBC error occurred:

Error: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed
State ID: HY024

—————————
OK
—————————

So, how do you get rid of this error message? Simple! If you are the one who needs to be uploading new license files, then ask your SQL administrator to give you (at least) sysadmin permissions on the server level:

Upload License File - Server Roles

Or, find someone else, who already has these permissions, and give him the task of uploading Dynamics NAV license file.

Technorati Tags: , , , , , ,

This entry was posted in Dynamics NAV / Navision and tagged , , , , , , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *