CR Service offering not showing after ICON change
I doubt if it has anything to do with the icon change, but a colleague was updating icons in the portal, republished the RO as a regular RO, realized the mistake and republished as an advanced RO, and then published the SO. ( The RO is the CR workaround ). Now the offering is missing form the portal, (but it is on the MS portal) and all previous CRs created have lost the ability to edit. I had the inability to edit issue before, and this turned out to be a permissions issue, but not this time. Gone through all the usual steps of resetting IIS/browser/Cache builder to no avail. One other oddity was that the first symptom was the loss of ability to edit from my Admin account, but may user account was fine, CR was available on the portal. Then in the process of trying to get the admin account back working, first the offering disappeared from the portal, then my regular account lost the ability to edit.
The cachebuilder log has this error, but this was after the initial problems:
2017-06-22 16:56:26,106, ERROR [ 4]: Error connecting to management server: The Data Access service is either not running or not yet initialized. Check the event log for more information.
So I am somewhat stumped her, maybe this is a SQL issue?