Page 3 of 3

Re: Jiwa on Azure

PostPosted: Tue Oct 31, 2023 1:03 pm
by Mike.Sheen
Create the users in master yourself associating them with the SQL Logins JiwaLogin, JiwaReports and JiwaUser.

Test if you can then login to SSMS using the SQL Login JiwaUser,

If that now works, then you then in your Jiwa database run the stored proc to grant permissions on the objects in the schema:

usp_Jiwa_Grant_Application_Permissions 'JiwaUser'
GO

usp_Jiwa_Grant_Reporting_Permissions 'JiwaReports'
GO

Note that recommended best practice is not to use the SQL Logins and Users JiwaReports and JiwaUser, but your own credentials instead. JiwaLogin is the only Login and User which must not be renamed and have the known password.

Re: Jiwa on Azure

PostPosted: Wed Nov 01, 2023 2:43 pm
by Riyaz
Thanks Mike, appreciate it