We have recently completed a fresh install of AGS Enterprise 10.5.1 and have installed Insights 2.1. Our environment consists of portal, a federated ArcGIS Server and a datastore that are all on separate servers. Any type of data that we have tried to add to Insights produces the "something went wrong" error. We are able to successfully add hosted data to our portal without any issues. When looking at our ArcGIS server logs we get the following error:
Failed to create data source ''[/enterpriseDatabases/AGSDataStore_ds_01jhriaz, com.esri.insights.APIException: failed to get data store user info]
We have had a few discussions with ESRI regarding this error and there has been some discussion about a user account that is supposed to be created on the datastore by the Insights installation called INS_XXXX. We have yet to resolve this issue and was going to see if anyone else has run into this problem and has any "insight".