I'm attempting to add a new data source from a SQL Server on Azure VM for a search service and indexer I'm creating through the Azure web portal. It's my understanding that I can create an index, import this data, then create an indexer to regularly push data to the index. I'm adding the connection string for our SQL Server and getting a successful message when clicking "Test Connection". The tables show up in a drop-down list, and I select one.
When I click "OK" on creating the new data source, a popup comes up that says "Sampling Data Source..." then an "Error detecting index schema from data source: 'Data source payload should specify at least one of datasource name and type'".
I've tried Googling this error, and I can't find anything on it and not sure how to fix it so I can proceed.
