no licence available

[Riyaz]

Hi There

We are migrating database to another server, followed the guidelines as per https://jiwa.atlassian.net/wiki/spaces/ ... SQL+Server , after migration is complete if we logon to Jiwa it says no valid licences available and it pops up all the valid licenses in the licence import box. Have tried deleting all and importing licences, but still no luck. Any advise pls.

[Riyaz]

to add on to that, the old server was 2012 and new one 2022, and in the old database SR18 version, no users were assigned a licence, it was working like pooled / concurrent licences. If I assign the seats per user then it works fine. Just confirming if that is the cause here.

[SBarnes]

Are both servers running the same service release, you haven't made that clear?

[Riyaz]

Hi Stuart

Yes same, SR18

[Mike.Sheen]

For concurrent licencing you need to have the VIEW SERVER STATE permission of the SQL Login set.

Try:

Code: Select all

GRANT VIEW SERVER STATE TO JiwaUser

Replace JiwaUser with the SQL Login you have configured for Jiwa to use.

Note that some SQL Server security configurations do not permit VIEW SERVER STATE and thus concurrent licencing will not be possible. If that is the case a CAL just needs to be attached to a Jiwa user as you've already indicated you have done.

[Riyaz]

Thanks Mike

Staffs are currently assigned on CAL today, I will try this after hours and see how we go.