SQL Server - Test Connection Failed

Like (0) Share

Report

Posted on 5 Sep 2023 09:04:41 by russmca

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!

All responses (1)

Answers (0)

Michael E. Gernaey 42,301 Super User 2025 Season 1 on 11 Sep 2023 at 00:12:04

Like (0)

Report

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