Skip to main content

Notifications

Community site session details

Community site session details

Session Id : J5jTtuRHsNx4Cg7mZkygPi
Power Automate - Using Connectors
Unanswered

SQL Server - Test Connection Failed

Like (0) ShareShare
ReportReport
Posted on 5 Sep 2023 09:04:41 by 44

Hi,

 

I am trying to set up a new SQL Server connection within Power Automate but I receive an error while doing so:

 

Test connection failed. Details: Microsoft SQL: Invalid object name 'sys.extended_properties'. Invalid object name 'sys.types'. inner exception: Microsoft SQL: Invalid object name 'sys.extended_properties'. Invalid object name 'sys.types'. clientRequestId: 59a783ca-4ff2-883e-d677-14972215dd0b

 

I can connect using the same details/credentials via SMSS from the gateway server. The SQL server is SQL 2000. Any help would be appreciated!

  • Michael E. Gernaey Profile Picture
    41,538 Super User 2025 Season 1 on 11 Sep 2023 at 00:12:04
    Re: SQL Server - Test Connection Failed

    Hi,

     

    Its possible the issue is with the binary collation setting on the database, making it case sensitive. I would definitely not be using SQL 2000 either, as you won't get any real support for that. Between (if its onprem) needing the Gateway to get to it, any issues you hit are mostly going to go unnoticed as its been out of support for so many years.

     

    However, validate your case of your database , tables, columns etc as you try to use the connector from Power Automate.


    Cheers
    If you like my answer, please Mark it as Resolved
    and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | Ex-Microsoft

    Site: https://gernaeysoftware.com

    LinkedIn: https://www.linkedin.com/in/michaelgernaey

     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,077 Most Valuable Professional

Leaderboard

Featured topics

Loading started
Loading complete