Does anyone know what this error means: Error: [Microsoft][ODBC SQL Server Driver]Database is invalid or cannot be accessed. State ID: HY024
It comes when I'm trying to upload a new license file to the server from the Attain 3.60 client.
Don't forget to "Verify Solution" the post(s) that solved your problem. This credits the experts who helped, earns you points and marks your thread as Resolved so we all know you have been helped.
An update 5 years later...
This can occur when the user attempting to perform the Upload of the license is not a member of db_owner in the NAV database.
The connected user must both be a db_owner, and also have UPDATE permission to the [$ndo$srvproperty] table in the master database, in order to upload a server license. Of course, any higher permissions is ok too, such as sysadmin.
Hi Dean,
Thank you. Even though this is over 6 years ago now, then I do know that the database was not in "single-user" mode. But I do know that there was other users online, also that there was more than one user online. But that's all.
Super Thx....Just couldn't understand why I wasn't able to create new Windows User for my new Romainian NAV Database! It was in Single User-mode because I had to change the sorting...
You just saved the day!!!
It's fantastic how good people contributing to such forums can help "the rest of the world". Thank you again!!!