Jiwa on Azure

[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.

[Riyaz]

Thanks Mike, appreciate it