AWS and RDS
Posted: Fri Oct 11, 2019 11:38 amIs Jiwa supported to be run under AWS and RDS?
Page 1 of 2
Posted: Fri Oct 11, 2019 11:38 amRe: AWS and RDS 
Posted: Fri Oct 11, 2019 2:47 pmNo. That's not to say it won't work though.
Re: AWS and RDS
Posted: Fri Oct 11, 2019 2:50 pm
that's what I told the person who asked as I said given a connection string and created users it should workRe: AWS and RDS
Posted: Sat Oct 12, 2019 11:09 amAlso just be aware our next release (7.3 and the dev builds preceding that - 7.2.2 onwards) leverage contained database authentication, which requires SQL 2012 or later (previously SQL 2008R2 was supported) - so whatever version of MSSQL which Amazon's RDS for MSSQL uses needs to be SQL 2012 or later.
Re: AWS and RDS
Posted: Wed Oct 16, 2019 10:16 amSee below, straight out of AWS documentation.
SQL Server 2017 RTM (CU13) 14.00.3049.1, released per KB4466404 on January 01, 2019.
SQL Server 2016 SP2 (CU3) 13.00.5216.0, released per KB4466404 on September 20, 2018.
SQL Server 2014 SP2 CU10 12.00.5571.0, released per KB4052725 on January 16, 2018.
SQL Server 2012 SP4 GDR 11.00.7462.6, released per KB4057116 on January 12, 2017.
SQL Server 2008: It is no longer possible to provision new instances in any region. Amazon RDS is actively migrating existing instances off this version.
SQL Server 2017 RTM (CU13) 14.00.3049.1, released per KB4466404 on January 01, 2019.
SQL Server 2016 SP2 (CU3) 13.00.5216.0, released per KB4466404 on September 20, 2018.
SQL Server 2014 SP2 CU10 12.00.5571.0, released per KB4052725 on January 16, 2018.
SQL Server 2012 SP4 GDR 11.00.7462.6, released per KB4057116 on January 12, 2017.
SQL Server 2008: It is no longer possible to provision new instances in any region. Amazon RDS is actively migrating existing instances off this version.
Re: AWS and RDS
Posted: Fri Apr 09, 2021 11:14 amHi,
Just wondering if there has been a change to Jiwa being supported on RDS?
Just wondering if there has been a change to Jiwa being supported on RDS?
Re: AWS and RDS
Posted: Fri Apr 09, 2021 11:31 amAs far as I know it's still not supported but as Scott said may work, the trick from having worked with Azure SQL is you need to make sure the requisite users JiwaLogin, JiwaUser and JiwaReports are created on the server with appropriate passwords.
The other thing is any databases regardless of being Jiwa ones also need to have these users as there was a bug related to this that I'm not sure has been fixed yet which causes issues with creating a connection.
The other thing is any databases regardless of being Jiwa ones also need to have these users as there was a bug related to this that I'm not sure has been fixed yet which causes issues with creating a connection.
Re: AWS and RDS
Posted: Fri Apr 09, 2021 12:32 pmScott/Mike,
Any potential change to this in the future given that Amazon are starting to make a push into the Australian SME market.
Any potential change to this in the future given that Amazon are starting to make a push into the Australian SME market.
Re: AWS and RDS
Posted: Mon Apr 12, 2021 11:40 amNinaT wrote:Scott/Mike,
Any potential change to this in the future given that Amazon are starting to make a push into the Australian SME market.
Hi Nina,
We think there may be nothing to do - but can't say for sure until someone spends the time to try.
I've logged DEV-8683 to verify that Jiwa does work ok with AWS RDS.
Re: AWS and RDS
Posted: Mon Apr 12, 2021 11:46 amThanks Mike, greatly appreciated!