Jiwa

Hi all

I am trying to move my Jiwa from an AWS cloud based server to my local PC where I am running SQL Server Express (latest version). The server is running fine, I have been able to restore the database and that all looks good, but when I go to create a new connection I am running into some strife.

I get a message saying I can't connect to localhost using jiwalogin (I have attached a screen capture of the message).

I have created a database user for jiwalogin with the specified password, and have give that user access to the resotred database.

What am I missing (I'm sure it's something simple)!

Thanks
Trevor

If you haven't already, take a look at https://jiwa.atlassian.net/wiki/spaces/ ... gon+Failed - it runs through the most common causes of this problem.

Hi Mike

I am able to connect to the database through the Microsoft Management Console, it just seems to be something to do with the JiwaUser login.

Regards
Trevor

If you've sorted out the issue with the JiwaLogin user and you are now getting an error with JiwaUser, then follow the same steps you did with JiwaLogin.

I am assuming you know the password for the SQL user 'JiwaUser'? And the SQL server is in mixed mode?

Create the user in SSMS:
<ServerName>
-- Security
-- Logins

While you're at it, create a user JiwaReports also. Assign both the JiwaUser and JiwaReports SQL users the same password - if you want, that's up to you.
Then open a Query window, confirm the database dropdown on the ribbon is set to the Jiwa database.

Run this in the query window.

Code: Select all

EXEC sp_change_users_login 'Auto_Fix', 'JiwaUser'
EXEC sp_change_users_login 'Auto_Fix', 'JiwaLogin'
EXEC sp_change_users_login 'Auto_Fix', 'JiwaReports'

Try logging onto Jiwa again.

Hi Mike

I did the backup / restore of the original Jiwa database again, and it all seems to have worked now. I can only assume that I had done something wrong in the original setup - just not sure what.

Thanks for your help.

Regards
Trevor