
I'm using the SQL Server connector in Flow. I've selected Azure AD Integration for the connection.
My environment's database version is 9.1.0.20151, so SQL connection is supported. I've turned on TDSEndpoint yesterday. I've not created any gateways - I'm not sure how to do that or if it's required for my case. My user role is System Administrator.
I want to connect to my CDS database, but I don't know my database name. In the dropdown for Database name, I'm getting a 404 "could not retrieve values" error. I can't use Enter custom value because I don't know any or what values to use. Even the Server name was not able to be loaded and I had to manually type it in as a custom value.
I've tried the same in another environment. Both have the same issue. (One is a sandbox and another is a production).
Can someone walk me through everything I need to do/know please?
Hi @qwert79 ,
Sorry for the function to enter custom database name in the SQL server connector is not supported in Microsoft flow currently and we could only choose the database from the drop down list.
Best Regards,
Alice
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.