New connection on SQL Server Express

[Trevor.Doble]

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

[Mike.Sheen]

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.

[Trevor.Doble]

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

[DannyC]

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.

[Trevor.Doble]

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