web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to use SQL Server ...
Power Automate
Answered

How to use SQL Server connector in Flow to connect to CDS database? Currently receiving database name 404 error.

(0) ShareShare
ReportReport
Posted on by 20

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. 

Clipboarder.2020.07.23-003.png

 

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?

Categories:
I have the same question (0)
  • Verified answer
    v-alzhan-msft Profile Picture
    Microsoft Employee on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 608

#2
Valantis Profile Picture

Valantis 416

#3
11manish Profile Picture

11manish 348

Last 30 days Overall leaderboard