Hi Everyone, I'm new to Jira 7.6 on my Windows Server 2012 and I'm trying to complete my first production installation. I did manage to install Jira with the initial built in database as a trial and that worked out fine and my team liked the product. We're now trying to install Jira into our SQL Server 2016. I know on the support page that only SQL Server 2008 and 2012 is officially supported but I read that 2016 is backwards compatible so it should also work. We setup the database in sql server 2016 and during the setup step, I tested the connection it connected just fine. Once I enter all the database information in and click on setup, the window browser throws an error "http://localhost:8080/secure/errors.jsp". When I go to the database and I see tables have been created in SQL Server 2016. Have anyone encounter this issue before?
SQL Server 2016 is not one of the supported databases and thus we cannot be certain of any issues that may arise as a result of using it. I have seen many examples where SQL Server 2016 was being used and even though it is "backwards compatible" it still does not work as expected and the issues can include startup issues, etc.
One suggestion I have seen from a user is to try running MS SQL 2016 in 2014 compatibility mode. Another user in the same ticket says they have it running in 2016 Compatibility mode so each environment is going to be different and unless the Database is on a Supported version there could be any number of things going on that we cannot troubleshoot as we have not tested and cannot guess at the behavior.
At this time I would recommend using the supported version. Setup a blank SQL 2012 database and then use the JIRA Configuration Tool to change the database to the supported version.
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs