I now have it working. It required a reboot and assigning the ArcGISSOC user db_owner permissions in SQLServer. For some reason db_datawriter is not enough to add the features to the geodatabase.
Glad you got it working. Was support helpful or did you figure this out before contacting them?