Confluence fails to start after upgrade

[Hanwi]

Hi!

We just upgraded Confluence  from 7.4 to 7.13.1 and receiving error below when starting confluence.

Really need some help here!

[Brant Schroeder]

@Hanwi Are you using MS SQL server?

[Hanwi]

Yes

[Brant Schroeder]

@Hanwi This is usually caused on MS SQL due to a lack of permissions on the account being used by Confluence to access the DB.  

Check and make sure that the account has the proper permissions.  Here is a guide you can follow: https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html

A quick check individuals do is to set the db-user as a sysadmin for the whole SQL Server.  If it starts then you know it is a permission issue.  Then you can remove sysadmin and follow the steps above to ensure proper permissions are in place.

[Hanwi]

I just tried that and it did not help

[Brant Schroeder]

Does the startup page load with errors on it?

[Brant Schroeder]

I think I found the issue, took a little digging.  https://jira.atlassian.com/browse/CONFSERVER-66547

[Hanwi]

Yes this one helped me https://jira.atlassian.com/browse/CONFSERVER-65134
Thanks!