Thanks Mike and Stuart
Have already tried this, even reupgrading the database. I think the problem is that the users dont exist in the master database. If It try to create them using below queries, I get the errors underneath the queries. Have also uploaded a screenshot
CREATE LOGIN JiwaUser WITH Password = 'JiwaFinancials123'
CREATE LOGIN JiwaReports WITH Password = 'JiwaFinancials123'
Msg 15025, Level 16, State 1, Line 1
The server principal 'JiwaUser' already exists.
Msg 15025, Level 16, State 1, Line 2
The server principal 'JiwaReports' already exists.