I am unsure how/why it happened:
During the upgrade the user I had previously set on our database server for our content store connection was deleted/removed from the database users. I added back the user on the database then Started the Cognos service to resolve the issue.